AutoNumber, 4 digits

[WantoN]

Hi guys,
I'm creating a new table, and want to create a field whereby when you enter a new record, a random 'Customer ID' is generated with four digits, which is never duplicated.

How do I go about doing this?

Cheers,
Antoni

 

[mp9]

1. Create a table with a field called Customer ID which is of type Long Integer.
2. Create a record in that table with a value of 999 in the Customer ID field.
3. Change the Custoemr ID field type to AutoNumber.
4. Delete the record created in step 2.

Auto numbers will then be created from 1000 up - they won't be random though, there'll be sequential, but they will be unique.

Hope this helps.

http://www22.brinkster.com/accessory/

 

[lespaul]

what are you going to do when you have 9999 customers?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[BNPMike]

what are you going to do when you have 9999 customers?

Buy a Ferrari?