Unique Number

[Sol]

Hi!

I need to create a 10 digit Customer Number which in which the first and last 2 digits come from fields on the entry form. The 6 digit part should be a sequential number incremented 1 one each time. Do you know how to go about this?

I realize the the number would have to be created on the after update event since it is partially based on fields the user is entering in.

Thanks!!!

 

[BarkerD]

Do you need to store the number, or just display it?

I would save all 3 numbers as separate fields, and then concatenate them to display.

Eg: CustNum field Control Source
= [1Digit] & [Autonumber] & [2Digit]

To ensure no duplication, use all 3 fields as the primary key.

Duane Barker

[This message has been edited by BarkerD (edited 01-26-2001).]

 

[Sol]

I would need to store this unique number each time as a Customer #. Do you know how I can create the 6 digit Number? The 6 digit part should be a sequential number incremented 1 one each time.

Thanks!