Automatic Number

[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.

 

[Joseph Meehan]

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.

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.