Autonumbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to autonumber using blocks of numbers i.e. 0 to 199 for one
table then 100 to 199 for another table?
 
Jonah said:
Is it possible to autonumber using blocks of numbers i.e. 0 to 199 for one
table then 100 to 199 for another table?
Click to expand...

No, nor should you need to.

Autonumbers exist for one purpose only: to provide a (practically
guaranteed) unique value that can be used as a primary key. The actual value
of the Autonumber field shouldn't matter to anyone: in fact, it's usual not
to let the user see the value.

Not only that, but there's no correlation between an Autonumber field in one
table and an Autonumber field in another table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine number in a Table field 1
WORKING WITH REVERSALS 3
Primary Key Autonumber - Is it the best choice for discrete ID num 11
Autonumber 4
Autonumber 12
Pivot Table Drop Downs 3
getting an autonumber field to go beyond 3999 5
Creating a new database can you assign auto #'s to start with 100 3

Back
Top