hello,, i wana know how do i concatenate Customer Last Name"3 Right Digits" and + "4 Digit Auto Number " .. so the total legth for the customer id field should be 7... Example(Far0001, Sto4040 etc)



i am doing it the other way i take maximum of the left 4 digit of the customer id field and add a to it and then concatenate it with the new memeber last name... however this does not work....

please could some one guide on how to do it both the ways ( Autonumber or adding +1 to the max number...)