Hi Jonathan

When you add your tables to the DE any parent-child rel's appear in the DE's ERD. You can click on a rel and delete it (it's ONLY removed in that form - not in your database). Then you can "draw" your own "reverse" rel by dragging the (official) child's foreign key field to the parent's primary key field.

This is particularly useful for, say, look-up tables in combos (i.e. when a look-up table value can be had by many main records, e.g. State, County, color code etc.). The parent, of course, officially, is the look-up table record, as it can have many records using it in another table. Thus when you change the form's main record the look-up value in the combo will automatically be updated.

Terry

>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