"Simple" Append Query

[Kila]

I am trying to do what *SHOULD* be a very simple append query.

The source query has 5 tables with NO key, indexed or required fields (although they DO have relationships between 4 of them to the main, 5th one that are internal to the query itself)

The destination table has NO required fields except the autonum field that does not have any data appending to it.

The append query looks identical to the source query if I change append to select.

BUT, I keep getting a key violation error for ALL the records in the source query.

HELP!!!

Thanks!

 

[KenHigg]

Maybe the destination table has fk/related table issue?

 

[Kila]

fk? What kind of issue might it have? Thanks.

 

[KenHigg]

You may be trying to put data in a field that requires a duplicate value in another table. If you view relationships you should see this...

 

[Kila]

That was it, or something similar. It was trying to paste numbers into a field that was limited to a list of numbers that did not include the ones the query was trying to put there. Fixed the problem & it worked. Thanks!

 

[KenHigg]

Cool - Glad you have it working -