Append Query Problem

[Bob M]

I have two tables Products and ProductsSupplierJoin. Both tables have ProductID and SupplierID. I want to append records to the ProductsSupplierJoin table from the Products table using the ProductID and SupplierID fields.
I've set up an append query according to the instructions on the Microsoft web site and all I get is 0 records appended.


What am I doing wrong???

 

[RV]

One quick guess:

>...using the ProductID and SupplierID fields. <

Are you perhaps trying to append rows that already exist?
Check this.
Otherwise, post your query statement.

RV

 

[Bob M]

I just figured it out. I built the query using the wizard and selected the Products table. I then selected the ProductID and SupplierID fields and clicked finish. I then went into design mode and clicked query and made it an append query. I selected the
ProductsSupplierJoin table as the table to append to then ran the query and it worked!

Before I assumed you needed both tables to make it work.

Thanks for your help. It pointed me in the right direction.