Microsoft KB Archive/165634

= PRB: View Wizard Loses Relations When Removing Field =

Article ID: 165634

Article Last Modified on 5/12/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Visual FoxPro 3.0b for Macintosh

-



This article was previously published under Q165634



SYMPTOMS
When creating a Local View with the View Wizard, there is an issue with relationships when two tables are used and a relation is created. If the user returns to Step 1 in the Wizard and removes a field or fields from the selected fields, the relationship is removed.



RESOLUTION
The user must simply re-add the relationship once returning to Step 2.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
  In the Command window issue the following command: MODIFY DATA HOME+"samples\data\testdata"  From the File menu, click New. Click View and select Wizard from the New File dialog box. In Step 1 of Local View Wizard, add all fields from Customer and Orders. Click NEXT to move to Step 2. Since Orders.Cust_ID and Customer.Cust_ID should be in the pop-up menus, click the Add button to set the relationship between the two tables. Click Back to go back to Step 1. In Step 1, remove a field or fields from the Selected Fields.</li> Click Next to return to Step 2. (NOTE: the relationship is gone and must be added again.)</li></ol>

Keywords: kbprb KB165634

-

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

© Microsoft Corporation. All rights reserved.