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


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
 
Ad

Advertisements

J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top