Importing to Parent and Child Tables in Access from Access Table

[trying to delete locking file .ldb]

I imported data from an Excel spreadsheet into an Access Temporary Table so
that I can import that data into a Parent table and then a Child table.

The import to the Parent table was successful.

Now I need to import data to the Child table and still have referential
integrity up and running. How do I get the Parent PK field over to the Child
FK field in a correct manner with the corresponding data?

 

[DanielS via AccessMonster.com]

The child field should contain a column referencing the parent. You may have
set the tables with autonumbers. Create a query that will join the data in
the link columns instead of the autonumber key field. then append.

 

[trying to delete locking file .ldb]

The child field should contain a column referencing the parent. You may have
set the tables with autonumbers. Create a query that will join the data in
the link columns instead of the autonumber key field. then append.