Key violations for 2 records on append

[buzzbait9]

Hello,


I've been reading through the Key errors but I'm not understanding how they apply to my application. I am appending records into a table from a main form and a sub form. I can append twice and then I get the key error.

Can't append all records in the append query. Type conversion, Key violations for 2 records. I don't understand why the subform lists the first 2 with no problem but if there are more than 2 it throws the error.

I have checked the possible reasons but there are no violations.

Does this sound formiliar to anyone?

Thanks

 

[vbaInet]

Duplicate keys (or IDs) perhaps? If the ID already exists and you try to insert a new record with the same ID, it will complain if that's set as the Primary Key. You need to explain more.

 

[buzzbait9]

Thanks for the quick reply.

I started typing more information but the thinking process allowed me to make it work. Actually answer my own questions.

The append query was joined to the table query ID to Table ID. When I changed it to the query tag number to table tag number, it worked. Tag number is unique but ID is the same.

Can you explain why so I don't make the same mistake in the future Appends?


Thanks

 

[vbaInet]

The append query was joined to the table query ID to Table ID. When I changed it to the query tag number to table tag number, it worked. Tag number is unique but ID is the same.

You've lost me.