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.
 
You must log in or register to reply here.

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

Auto number in an existing table 4
The next Grand Theft Auto title has been officially announced 0
Auto numbering 1
Data Entry Form and Auto Number ID 2
MS Access problem 0
Match/Duplicate/Auto fill certain fields from different tables 3
auto number in query 1
Auto Number 3

Back
Top