is there a way that 2 separate tables can assign auto-serial numbers to records, using the same sequence? for example; table1 and table2 both assign autonumbers using the same sequence so that no one serial number is used in both tables.
thanks
josh

Josh,
What type of relationship exists between the 2 tables?

Would it be possible to place the 2 tables in question on a 1:1 relationship and link them via Autonumber field as the PK in Table 1 and Number(long int) field as the FK in Table 2?

Loralee

Hi Josh,

The simple answer is no. But the deeper issue is it sounds like you're attempting to use autonumbers in a way that assigns business meaning to them, which most folks who design a lot of DBs would recommend against. Autonumbers aren't intended to carry business meaning (i.e., serve as a data item, such as a meaningful serial number). They are designed to serve a logical function, not a semantic one. They provide a simple and consistent way of uniquely identifying a record in your database (primary key), but only your databse should ever need to know their value. They are generally hidden from the end user. Apologies if I'm off the mark here, but I suspect that what you are trying to do is something you wouldn't want to do, even if it were possible.

HTH,

Bob

Put another way...there is no good reason why one table in your db should care about, or even know, what the autonumber values in another table in your db are.