Say we have an Access database that was sent to three people. There are two tables with autonumbered ID's, parent-child (one-to-many) relationship with the second table. Is there an easy way to import all three dbs into an exact blank copy of their db? The problem is that since there are related tables, you don't know what the new id's are if you import the parent table first. Then it is a hassle to go in, join the new id, create a new autonumbered field, etc etc.

Right now I am changing the autonumbered fields to integer in each individual database and renumbering them through an update query (cascade) sequentially so that each record throughout all three are unique, then merging these all together.

Is there a way to insert parent-child records in one go without having to do all of this? Cascade the related table with the new ID it gets when inserting?