How to set up table joins to append unique records
in reference to:
We want to append data from remote databases to a central office db.
I want to combine a text string with the auto number so that the default auto numbers from different data sources would not result in a duplicate.
The text string would have hundreds of duplicates.
I use a default value for the text string ( [Location] )for each remote database location.
The auto number would have 1 dup for each table created remotely.
We want to combine unique records.
When appending to the main database, in order to prevent duplicates the append query table join would be set up...
That is the point where I thought that I would require a seperate unique ID field
It looks like I just need help setting up the joins for the append query?