How is an employee related to a hardware now? What you need to do is to load
the data into the parent tables (the "one" tables), and then use those
tables along with the original table (joining from the original table to the
new tables on a field that uniquely identifies the data in the parent
tables) in order to append data into the child tables (the "many" tables).
You'll need to give us more information about your exact setup and data for
someone to give you more specific info.

--

Ken Snell
MS ACCESS MVP

"Stranger" wrote in message
. ..
Situation:

Computer inventory is currently in one table.

I have created a new database with several tables related together for the
new inventory database. Now, I have created several append queries that
will append all the computers into the computer table, the employee info
into the employee table, printer info into the printer table, etc. If I
run all of theses append queries seperately, the employees are not
associated with anything. So, How can I get these to run but keep the
employee associated with the proper hardware?

thanks.