Alternative to AutoNumber?

[colinrharris]

I dont really want to touch the autonumbers in my customer database as these are critical to synchronise related tables. However, for various reasons, these dont really make sense for use as a unique customer reference. As Access does not allow a second autonumber in a table, is there another way I can have a new number generated in one of the tables?

Thanks

 

[PHV]

Have a look here:
faq181-158 faq181-1179 faq181-1725 faq181-159 faq181-1023

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886