P
pcurran
I have an excel file where each row contains contact info about a paren
(name, address,e tc) and info about 1 child (name, dob, etc). Othe
children for that parent are listed in subsequent rows with the sam
parent name and address="second child".
My access database has tblContact for parent info (primary key
autonumber) and is linked to tblChild for each child's info (1 t
many).
I have imported the excel file to a table from which I successfully ru
an append query to store all the parent info in tblContact but I don'
know how to even begin to add the child records for the appropriat
parent.
Any ideas on how to begin or an example to follow? Thanks
(name, address,e tc) and info about 1 child (name, dob, etc). Othe
children for that parent are listed in subsequent rows with the sam
parent name and address="second child".
My access database has tblContact for parent info (primary key
autonumber) and is linked to tblChild for each child's info (1 t
many).
I have imported the excel file to a table from which I successfully ru
an append query to store all the parent info in tblContact but I don'
know how to even begin to add the child records for the appropriat
parent.
Any ideas on how to begin or an example to follow? Thanks