Key Violation without a Key

[clubinski]

I am transferring data from 3 data tables into a separate table that is the combination of all 3. the First table appended no problem, the second one appended all but 18 records of the 4989, and the 3rd table errored and did not append 1272 records of 6662 due to key violations.

Sad thing is neither of the 3 tables I am appending from to the table I am appending have PK and no fields are required.

Any ideas what this can be?

Ran an Unmatched query to come up with errors missing more files that I even have then these 3 tables.

 

[clubinski]

Check for unique indexes. They are considered "keys" in this context.

Thank you for your response, but I looked no unique indexes, and while i was waiting for a reply I did run C&R on a copy of the database and it ended up finding all but 18 records so I ran another unmatched query on both tables because I am assuming that its not the 18 records I was missing from the first conversion I ran the query on both tables and still giving me a bunch of different files that are unmatched.