I want to load 3,00 more records into my database. I know I will be loading some records which already exist in the db.
I usually use an append querry, and set the primary key to to the field that will strip the duplicates.
However my concern is that many of my exisitng records have many notes. When I do an append query, how do I know which dups will be deleted, obviously I dont want to delete the existing records, that contain notes

Thank you for reading this
George

George,

When you run your append query, if there is a primary key conflict, then the record you are attempting to append does not get appended, leaving the original record intact.

Patrick