Autogenerate Unique Key

[randy remark]

OK, I have a prospects manager database and a customer database. The record identifiers Prospect No, and Customer No are the unique fields that I use for relationships etc.

What I want to do?

When I create a new record in either database I want it to be unique to both databases

for example:

In the Prospect Manager I have these records

01 Mr Smith

02 Mr Bloggs

In the Customer File, I create a new record and

it automatically is allocated 03 as the record identifier.

If I then were to create a new record in the Prospect database it would be given 04

I hope this makes sense

Thanks

[andygaunt]

OK Mark,

What about a preferences database that has the serial number in it. Then when you create a new record in any database, set that value to itself + 1, or if using version 5.5 use Set Next Serial Value.

Call this number from any of the databases.

Is this going multi user because this might become an issue.