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