>Hi All,
>
>Is there a "generic" way to get back to the correct record in the parent table after a specific search on the child table?
>For example, the pointer moves in the child table following a move in the parent. Thats inherent in a relation. Is there a "smart" way to do it in reverse?
>
>Thanks, J
You can set a relation from child to parent.
However, if you have one grid for the parent, and another grid - in a separate form, or in the same form - that shows related child records, then, quite simply, there is no reverse. The user will only see the child records that correspond to the parent record, and has to select another parent to see other children.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)