I need to automatically assign an alphanumeric serial number from a serial numbers table to another table. This is not an autonumber. This needs to occur on each new record, no duplicates allowed. I will populate the serial numbers table with virtually thousands of unique alphanumeric serial numbers such as C100001, C100002, C100003 and so on. I need to have the next serial number in order used on each new record.
The other question is do I have to list each serial number individually or can I list a range of serial numbers such as C100001 to C200001. This would be much easier.
Also, how do I accomplish this. Is there a sample database I can use to accomplish this. Thanks for any assistance. Randy