Primary key

G

Garry

Hi

I can create a new table from two tables. Can I ad a primary key
(autonumber) the same time. cheers
 
K

Ken Sheridan

Not if you are using a simple 'make table' query, in which case you can add
an autonumber column to the table in design view afterwards however.
Alternatively create the new empty table first, including an autonumber
column defined as the primary key, and then append the rows into the new
table.

Ken Sheridan
Stafford, England
 
Top