Primary Key

  • Thread starter Thread starter Mat
  • Start date Start date
M

Mat

Hi

How can you set a primary key number (autonumber) to start
from a particular number - eg "10000"

I have invoices issued from an old accounts package - and
am creating a new database to replace it, but do not want
to duplicate old invoice numbers. I seem to remember in
the past a way of setting this but cant remember - any
help please ?
 
Mat said:
Hi

How can you set a primary key number (autonumber) to start
from a particular number - eg "10000"

I have invoices issued from an old accounts package - and
am creating a new database to replace it, but do not want
to duplicate old invoice numbers. I seem to remember in
the past a way of setting this but cant remember - any
help please ?
Click to expand...

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.
 
Back
Top