make table query with primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a make table query which works fine. How can I get the table it
creates, have a primary key on one of the fields?

Thanks.
 
You can't do it in the Make Table query.

You can open the table in design mode and set the primary key.

Better solution,
Create the table ONE time with the appropriate indexes and set the primary
key.
Delete the RECORDs from the table
Append records to the table (instead of using a make table)
 
Back
Top