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.