Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refreshing child records on a 1 to many relationship
Message
 
To
20/01/1997 10:10:44
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00017812
Message ID:
00017926
Views:
57
>>When a record is changed in the parent table (for example from the command line with "skip 1"), we would like the appropriate records to display for the child. The relation is being set programatically. Ultimately we want the child records to display in a grid on a form. Right now we have 2 browse windows and see that the child records display, but the relation doesn't update until you actually click on the _parent_ browse window. Activate window child doesn't even refesh its contents.
>>
>>More concisely, in a one-to-many relationship, the "many" side is not properly reflecting changes made by moving through to parent table.
>>
>>Any help on the subject would be greatly appreciated.
>
>I think (and hope not mistaken) that there are 2 things you can do:
>
>1. GO (RecNo("Master")) In ("Master")
>2. GO TOP IN ("Child")

We put a refresh of the child grid into the AfterRowColChange event. This gave us the right data whenever we changed Master records with the mouse or keystrokes. In addition, we called this event during the form refresh, which took care of initializing the master grid or changing the active master record some other way.

Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform