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,
Sally [sig][/sig]
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,
Sally [sig][/sig]