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