Importing to Parent and Child Tables in Access from Access Table

[Guest]

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.

 

[Guest]

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.

 

[Jamie Collins]

The child field should contain a column referencing the parent.

I don't know what you mean by "field should contain a column". A table
is referenced via its PRIMARY KEY or a UNIQUE constraint, which may
comprise one or more columns (a.k.a. fields).

Jamie.

--