Auto Number

[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

 

[Steven Burn]

It should do that itself aslong as you've linked the tables.

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk

 

[DeVille]

Thank you

-----Original Message-----
It should do that itself aslong as you've linked the tables.

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk




.

 

[John Vinson]

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

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?