How to lock tables together?

[Bob DeMartino]

I have several tables that contain a field with the same "last name" and a field with a "serialized ID number" in each record. Also have linked them via relationship. How can I make all tables match up when I move between records.

eg, if a record in table 1 is accessed via ID # or last name, can I force all other linked tables go to that ID # or last name with out manually manipulating each table?

As it is, I have to manually adjust each table to that corresponding ID field or Last name field. Any suggestions?

[jcarson]

Try specifying a button on the layout to go to a related record. Then click that button to jump to whatever layout you want to go to.