Custom Autonumber

  • Thread starter Thread starter Phil Quinby
  • Start date Start date
P

Phil Quinby

Hi,

I would like to be able to start off the autonumber field at a number say
10000 so I can use it to generate 5 digit membership numbers. Is this
possible? - I was hoping to be able to use this as the unique record id
too.

Many thanks

Rob
 
Just be aware that Autonumbers really aren't intended to have meaning: their
sole purpose is to provide a (practically guaranteed) unique value that can
be used for a primary key. They are not guaranteed not to have gaps in the
numbering. If you can live with that, then yes, what you want to do can be
done.

Create a table that's identical to your membership table, except that the
Autonumber field is simply a Long Integer. Create a dummy row in that new
table, with the ID set to 9999. Write an append query to append the contents
of the new table to your real membership table. When you insert the first
real member into the real membership table, it will get an ID one larger
than the largest used so far: in other words, 10000. Once that member has
been added, you can delete the dummy row.
 
Back
Top