Append New Records

  • Thread starter Thread starter jimmy.kirk
  • Start date Start date
J

jimmy.kirk

Is there a way to append only new records from a linked table to an
Access table? I see the non-matching wizard but it's only based on one
field. Any help would be appreciated...

Thank you,

Jimmy
 
Probably what you need is a multiple field index set to unique. In design
view of the table click on the menu VIEW - Indexes. You can create a new
index using the desired fields and set to Unique.
When you append you will not get duplicate records - BUT you may not get
any updates to those same records where information outside of the index
fields were changed.
 
Back
Top