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

[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

 

[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 ...