append key violations

[danabides]

im trying to perform an append query, but for some reason cannot due to 'key violations'.

the primary keys in both tables are exactly the same. im trying to append a row from one table to the other without creating additional records.

i can do the append, creating additional records when i remove the primary key from the destination table, but that wont work. and im getting sick of cut and paste.

any thoughts?

 

[ajetrumpet]

PK's are identifiers...a row with a PK of "2" identifies the record in the source table only, it is not interchangable with another record that happens to have a PK of "2" as well. It's a separate identifier.

im trying to append a row from one table to the other without creating additional records.

An update query would probably be easier to do here instead...

 

[danabides]

thanks pat and trumpet. my life just became so much more pleasant.