Append one table to multiple tables?

  • Thread starter Thread starter Stranger
  • Start date Start date
S

Stranger

I currently have the computer inventory at work in one table. I have
created new tables with relationships and I want to append the data in the
existing table so that it populates all of the new tables. Thus keeping
employees associated with their PC, printers, etc. I have tried creating
an append query but when ran it says it will append 0 rows. Any idea?
 
Hi,

One of the beauties of relational DBs is not having to repeat the same data in multiple tables. But if you must append the same data to each table I suggest copy and paste table rows as the easiest option.

If the append query didn't work I suggest that perhaps the table structures may have been different - a field in one table but not in the other.

Laurie Eaton
 
Hi,

I don't want to put the same data into multiple tables. I want to take
the one table that has all of the data and use the query to populate the
tables that I have created to seperate the data. this way I would have
all of the info related to each pc in one table, who it is assigned to in
another and the printer ifo would be in it's own table. But keeping the
relations so I know who is using the specific equipment. Does that make
since?
 
Back
Top