primary key set by make table query

  • Thread starter Thread starter Randal
  • Start date Start date
I'm not sure if you can do it in the make table query
itself, but you could make a very simple macro that first,
runs the make table query, and second, assigns a primary
key into the new table. i believe this only works if the
field you want as the primary key is the first column.
 
Can you give me more details? I can't find a macro action that sets a
primary key.
 
You must log in or register to reply here.

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

Edit primary key values 3
Executing a make-table query using multiple primary keys 8
Set primary key with make table query 1
Make-table issue 2
Changing existing primary key to autonumber 2
Fixing up field with a row number to become PK 1
Query for Forecasting Fuel Usage 1
Append to table with 2 fields in Primary Key - last is an autonumb 1

Back
Top