Customising Autonumber

[rookie1985]

Hello All,

I was wondering if anyone has any idea if it is possible to "customise" the primary key or Autonumber, whereby a company's invoice number prefixes or suffixes the autonumber. Alternatively is it possible to create a number where it increments by 1 when a new record is created. I know it is probably simple, but I am new to Access and cant seem to find anything in the help file.

Thanks in advance.

 

[mdlueck]

In general it is very bad to tie other business logic to the value of autonumber fields. The autonumber fields are unique to the application, but not guaranteed to remain the same forever... like through export/import or DB compact operations.

You should develop your own mechanism / code for generating sequential numbers on your own and use that as the InvoiceNumber field whereas the unique ID autonumber field of the record remains hidden and for system use only.