key violations

[pcEars]

I've designed an append query that returns the correct results in preview, but raises key violation errors when run.

I've searched all over for help info to correct this, but have found little to guide me.

Any ideas?

 

[Jack Cowley]

You will have to determine which field is causing the problem if you can't tell from the error message that Access puts up. You can delete fields one at a time until you find the one that is causing the problem and then you can usually tell what the specific problem is (datatype mismatch, duplicate key, etc...).

hth,
Jack

 

[pcEars]

That's tough to do, Jack. There's only 1 field being appended. (other fields are only used for criteria)

It is a lookup value from a table of names. What displays is the list of names, but the actual value appended is the primary key from that lookup table.

It is being appended to the lookup field in the destination table.

If the data type is the problem, then I don't know how to proceed.

CANCEL THAT!!!!

Jack, you were right. It was the data type! and with a bit of other tweaking I've got it working even better than I hoped!

Many, many Thanks!!!

 

[Jack Cowley]

You are welcome. Glad you got it working!

Jack