Append to table with 2 fields in Primary Key - last is an autonumb

  • Thread starter Thread starter John D
  • Start date Start date
J

John D

I want to append data to a table with a "concatenated" primary key - 2 fields
(OrgID + autonumber). I set up the Append Query correctly (Pretty sure - do a
lot of them). I get error message saying it won't add the records because of
a key violation.

I thought a table with an autonumber in the primary key would automatically
increment the autonumber while an Append Query executed. Not only that, but I
KNOW that there are no matches to the OrgID in the table as well.

Any ideas? Thanks.

John D
 
Never mind. Got up this morning, tried it again, and it worked!

Gremlins - little creatures deep in the dark - I'm sure there's a logical
explanation, but ...
 
Back
Top