Append Query

[PPCO]

I am trying to append data from tblitemline to tblitemlist. I only want to
append new records. The unique field is ListID. I want to append 4 fields
total. I can't get it to limit it to new records. Any help would be
appreciated. Thanks!

 

[Ron2006]

New on the basis of what criteria.?

Whatever that criteria is it should either the primary key (there can
be multiples fields involved as the primary key) or Indexed with NO
duplicates, (this will work if the criteria is a single field).

Once you set the table up that way, the append query will only add
"new" records.

You can still have a listID as an autonumber to allow using it as a
link to other tables if you want or desire to.


Ron