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