Hi everyone
I want to set a field(Customer Code) as follow in my customer table
A unic 6 alphanumerical digits taking the two first letter of the FirstName and the LastName from the other filed
Example FirstName= Sherlock LastName=Holmes
So the 6 alphanumerical IN THE CUSTOMER CODE FIELD will look like this=SH0001
Thanks
Bakar