PRB: SET RELATION TO Has No Effect in Grid from Child

• Microsoft Visual FoxPro for Windows, version 5.0

SYMPTOMS

If you create a form containing a grid whose record source is a child table in a relation that is broken with the SET RELATION TO command, the grid behaves as if the relation were still set and continues to show a subset of records from the child table.

CAUSE

For performance reasons, the relation information is cached and is not reread until the grid is forced to reevaluate its record source.

WORKAROUND

Set the grid's record source to the grid itself to clear the cached information and to force the grid to reevaluate its record source, as in the following example:

   Thisform.Grid1.RecordSource = Thisform.Grid1.RecordSource

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a new form called Temp.

2. Add the following two tables to the data environment:

         VFP\samples\data\customer.dbf
         VFP\samples\data\orders.dbf
   

3. Add a text box to the form.

4. Set the text box's ControlSource property to the following:

         Customer.cust_id
   

5. Add a grid to the form.

6. Set the grid's RecordSource property to Orders.

7. Add a command button to form.

8. Place the following code in the Click method of the command button:

         SELECT Customer    && Select Parent table
         SET RELATION TO    && Turn off relation
   
   

9. Run the form.

10. Click the command button.

To incorporate the workaround into this example, add the following code as the third line of the Click method of the command button on the form created above:

   Thisform.Grid1.RecordSource = Thisform.Grid1.RecordSource