Append one table to multiple tables?

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

"Stranger" wrote:

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,

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?





=?Utf-8?B?TGF1cmllIEVhdG9u?=
wrote in :

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

"Stranger" wrote:

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?