Make a Table Query

D

Diana

Hello,

I have a make-table query and I am trying to find a way
to add an auto generated numbered field called ID (which
I will be using it as a primary key.)

I know that I can add it later on once the table is made
but I would like to have this process automated.

Is there any trick to do so?

Thank you for your time and help!

Diana
 
B

Bill Crawford

hi:

In the table your using for the make-table query, add the field name with
autonumbering and turn primary key indexing on for the field
 
Top