Microsoft KB Archive/192860

= PRB: Creating Join in Join Condition Dialog Box Creates Filter =

Article ID: 192860

Article Last Modified on 12/11/1999

-

APPLIES TO


 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q192860



SYMPTOMS
When creating a remote view though the View Designer, if a join condition is specified in the Join Condition Dialog box, the join condition is specified as a filter rather than a join.



RESOLUTION
If you desire to use the Join syntax, you should use the Join tab to specify your join condition. You can also use the CREATE SQL VIEW command to create the remote view.



STATUS
This behavior is by design.



Steps to Reproduce Behavior

 * 1) Create a remote view though the View Designer.
 * 2) Add two related tables, and note that the Join Condition dialog box is displayed.
 * 3) Create a join in that dialog and close the dialog.
 * 4) Click the Join tab in the View Designer, and note that there is no join specified there.
 * 5) Click the Filter tab in the View Designer. Note that there is a filter entered that matches the join condition specified in the Join Condition dialog box.

Additional query words: kbDSupport KBDSE kbVFp600 kbDatabase KbDBFDBC kbDesigner

Keywords: kbprb KB192860

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.