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)
 

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

Similar Threads

Executing a make-table query using multiple primary keys 8
Updateable Query Problem 9
Edit primary key values 3
Make-table issue 2
Primary Key Index in Make Table Query 3
Append Query To Table 3
Non-updateable query issue 24
Changing existing primary key to autonumber 2

Back
Top