Automatic Number

  • Thread starter Thread starter Rolando São Marcos
  • Start date Start date
R

Rolando São Marcos

I Have a table socio(idpartner, number, name,...).
The attribute idpartner is an automatic number, how can i make the attribite
number also an automatic number?
When i registe a new partner, the number for that attribute will be
generated automatically

Thanks.
 
Rolando said:
I Have a table socio(idpartner, number, name,...).
The attribute idpartner is an automatic number, how can i make the
attribite number also an automatic number?
When i registe a new partner, the number for that attribute will be
generated automatically

Thanks.
Click to expand...

Access only allows one autonumber filed per table.

Now the question is why do you want two different unique number in each
record in the table. Why will one not do it?

You can make your own autonumber of sorts usually using the Dmax
function.
 
Back
Top