Auto Number

  • Thread starter Thread starter DeVille
  • Start date Start date
D

DeVille

I have two tables table A and table B they both have
fields that are auto numbered, how do I prevent table A
from using any number in the auto numbered field that has
already been used in table B's auto number field
 
I have two tables table A and table B they both have
fields that are auto numbered, how do I prevent table A
from using any number in the auto numbered field that has
already been used in table B's auto number field
Click to expand...

You can't (Steven is mistaken).

This is a clear violation of normal form. A table's Primary Key should
uniquely identify a record in that table, and should not depend on any
other table!

Are you perhaps missing a table? It sounds like these two tables are
Subclasses of some other entity. What do the tables represent? Could
they both be in a one-to-one relationship with a master table with an
autonumber ID?
 
John is correct. If both fields have auto numbers Access will create
numbers as it needs.

It sounds like you are either misusing auto numbers or the construction
of your tables is not correct.

A little more information about exactly what you have and why this is a
problem would be helpful.

Keep in mind, that auto number is only there to provide unique numbers,
nothing else. It is not designed to keep those number nice and neat, just
unique.
 
Back
Top