Random Number

[ridgeandgable]

Hi Lads,



How can I add a unique random number as a customer ID? I would like it to be the First initials of the CustomerName and a 4 digit number? So for myself it would be HL1234 (Harry Lodge)

[pbaldy]

Easiest would be to use an autonumber field as the key, and concatenate the initials to it when displaying to the user.

[Micron]

I notice you didn't start with 1. The answer is a good one, but I'm guessing you won't be happy with H1 for you and M2 for me. You might want to seed the autonumber start, or post back if you had a specific "format" in mind, such as leading zeros or always 4 digits or whatever.