PRB: View Wizard Loses Relations When Removing Field

 Last reviewed: March 24, 1997
Article ID: Q165634
The information in this article applies to:
  • Microsoft Visual FoxPro for Macintosh, version 3.0b
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a

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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. In the Command window issue the following command: 

          MODIFY DATA HOME()+"samples\data\testdata"

  2. From the File menu, click New. Click View and select Wizard from the New File dialog box.

  3. In Step 1 of Local View Wizard, add all fields from Customer and Orders. Click NEXT to move to Step 2.

  4. 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.

  5. Click Back to go back to Step 1.

  6. In Step 1, remove a field or fields from the Selected Fields.

  7. Click Next to return to Step 2. (NOTE: the relationship is gone and must be added again.)

Keywords : FxtoolQueryvwdes FxtoolWizother kbtool VFoxMac vfoxwin
Version : 3.0 | 3.0 3.0b 5.0 5.0a
Platform : MACINTOSH WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 24, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.