Hi
Thanks for helping me and I am sorry that I have misled you in any way:
1. There 2027 records in the input table
2. The output table has an autonumber primary key and should simply add records - even if I had run the append query twice I would then have duplicates
3. The append query fails 2027 records with a key violation - therefore none were added.
I made a simple copy of the two files involved but stripped out most of the records. Cust na in the target file and Append input is the input file. Now you should be able to see all the field definitions. BTW, all the fields on the input are used to update the Cust na.
File will be sent soonest as I need to zip it
It worked simply meant that following your instructions I finally added the JPG
Regards
Tony Randel