Not exactly sure of your meaning in your first post, but if you intend to tie the auto numbers for the popup form records to auto numbers in any other table, you cannot rely on this.
The key that I am looking for is how to tie them together using the user's AutoID
Your subsequent post seems to support my guess. You need to use some other field that is common to all tables that are related to the main one. If that needs to be an autonumber id from the main table because you have no unique distinguishing value (such as employee number), then you must write that auto number value as a foreign key value to any other related table. Only then could you "link" tbl2.ForeignIDValue to tbl1.YourAutonumberField.
You might benefit from more insight about autonumbers. Maybe you'll have to rethink your tables design. FWIW, that page ought to have "Meant to be used as meaningful data" as the #1 in the NOT list. Seems like an oversight to me.
Hopefully you designed the popup forms to be modal so that the main form and popups that weren't closed don't get out of sync.
Last edited by Micron; 02-19-2018 at 08:19 PM.
Reason: spelin and gramur
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.