Key Violation errors - Expert advice needed

[SallyG]

I have a table that I am try to add new records to using an append query.

All the fields in the query are of the same data type as the table i am appeneding into, everything matches perfectly but when I run the query i get the error msg, "didn't add XX number of records to the table due to key Violations".

Now if I remove my primary key from the AutoNo ID field in my table they append OK but as the key is removed, they append all over the place and not sequentially as the existing records are. Access starts assigning IDs from EXISTING records to the new ones which means when I display the records in a from, the wrong records show up.

Any ideas on what I am doing wrong here ?????

Thanks in advance,


Sallyg [sig][/sig]

 

[MichaelRed]

Sally,

It is not "doing wrong", it is understanding!

If you have an autonumber field in the destination table, the destination table MUST assign the number to each record as it is created - IN THE DESTINATION table! Importing a value into this field is the violation. You can either have the autonumber field in the source table - and import the value into a (long integer) field in the destination table - or you can have the destination table autonumber the impor records - not both! [sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]