DOCUMENT:Q163787  22-FEB-2000  [foxpro]
TITLE   :FIX: Form Wizard Doesn't Limit Grid Contents to Related Record
PRODUCT :Microsoft FoxPro
PROD/VER:WINDOWS:2.5,3.0,3.0b,5.0,5.0a
OPER/SYS:
KEYWORDS:kbtool kbvfp kbvfp300bBUG kbvfp500aBUG kbvfp500bug kbMDAC250kbbuglist

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a 
 - Microsoft Data Access Components version 2.5 
-------------------------------------------------------------------------------

SYMPTOMS
========

If you use the One to Many Form Wizard from a remote view, the grid created by
the Wizard does not limit the contents to the related records.

RESOLUTION
==========

To work around the problem, add the following line of code, as indicated, to the
txtbtns.NavRefresh() method in the Visual FoxPro \WIZARDS\WIZSTYLE.VCX:

         CASE THIS.ViewType = 1        &&local views
            SET FILTER TO &cFiltExpr
         CASE THIS.ViewType = 2        &&remote views
            SET FILTER TO &cFiltExpr   && Add this line to the method
         ENDCASE

STATUS
======

Microsoft has confirmed this to be a bug in the Microsoft products listed at the
beginning of this article. This has been corrected in Visual FoxPro 6.0.

MORE INFORMATION
================

Steps to Reproduce Behavior
---------------------------

1. Issue the following command in the command window:

         MODIFY DATABASE HOME()+'samples\data\testdata'.

2. Create a remote view to the testdata!customer table using the Visual FoxPro
   ODBC driver.

3. Create a remote view to the testdata!orders table using the Visual FoxPro
   ODBC driver.

4. Run the One to Many Form Wizard.

5. Add the remote view to customer as the parent and select the Cust_id field.

6. Add the remote view to orders as the child and select all fields.

7. Select Finish and run the form.

Additional query words: kbvfp600fix

======================================================================
Keywords          : kbtool kbvfp kbvfp300bBUG kbvfp500aBUG kbvfp500bug kbMDAC250 kbbuglist
Technology        : kbVFPsearch kbAudDeveloper kbMDACSearch kbMDAC250 kbVFP300 kbVFP300b kbVFP500 kbVFP500a
Version           : WINDOWS:2.5,3.0,3.0b,5.0,5.0a
Issue type        : kbbug
Solution Type     : kbfix

=============================================================================

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.

Copyright Microsoft Corporation 2000.