What can I add to the ALTER TABLE column addition of an autonumber field to also make it the "primary key"?
"ALTER TABLE DonRegFam ADD COLUMN FamDonID COUNTER"
What can I add to the ALTER TABLE column addition of an autonumber field to also make it the "primary key"?
"ALTER TABLE DonRegFam ADD COLUMN FamDonID COUNTER"
SQL (untested) and assuming field FamDonID exists at this time
ALTER TABLE DonRegFam
ADD PRIMARY KEY (FamDonID)