Create a primary key in a make table query

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

Guest

When I create a new table via a make table query, I would like the queried records to be uniquely identified. Is there a way of automatically generating a primary key field in a make table query? I see in Tools/Options/Tables/Queries that there is a AutoIndex option - but I don't understand how this works

Any ideas

Thank
Nigel
 
Instead of using a make table query, you might consider creating the table
beforehand (with the primary key field and whatever else you want), and then
using an append query to populate it. If you want to "empty out" the table
before, you can run a delete query before running the append query.

Nigel said:
When I create a new table via a make table query, I would like the queried
Click to expand...
records to be uniquely identified. Is there a way of automatically
generating a primary key field in a make table query? I see in
Tools/Options/Tables/Queries that there is a AutoIndex option - but I don't
understand how this works.
 

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
Make table query: [Enter 1] AS Test 1
Make-table issue 2
Primary Key Index in Make Table Query 3
Changing existing primary key to autonumber 2
Set primary key with make table query 1
Edit primary key values 3
make table query with primary key 1

Back
Top