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.
 
Back
Top