Microsoft Access

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

Rolando São Marcos

In the table SOCIO(IDSocio,Nome,Numero,...), the attribute IDSocio is an
Automatic Number.
How can I do the same for attribute Numero, make this attribute automatic
when i insert new values in the table?
Thanks.
 
Rolando

Access only permits one "Autonumber" field per table. If you wish to use
other fields for numbering/sequencing, you'll need to create your own. Try
mvps.org/access and/or Google.com, and look for "custom autonumber" (they
are not true 'autonumbers', but this is how they have been described).

Good luck

Jeff Boyce
<Access MVP>
 
You can set the default value of a number field to a calculated value.

An example would be a query to return the maximum number in field +1.
 
Back
Top