Voilations

[khurram7x]

Append Query of mine is adding half records from another table in a table. For rest of the records, it shows the violation error as attached. Whatever the number of records are, it only adds half of them!!

My confusion is, if there's a violation, then why it is adding half of the records and give error for rest of the records??

I tried anything where I had a chance of violation, but nothing. Any ideas please?

 

[spikepl]

Show your structure. What you've shown so far is weird. Also, key violation can be inserting same stuff twice. For somone to help you there you need to show the data and say what was accepted and what wasn't - wailing and crying does not help, only hard data can do the trtick.

 

[khurram7x]

Sorry, the way I described the problem was not intuitive. I've got the problem solved. Thanks for help.