Unique in field
Ok, I am trying to set a customer id based on first 3 letter of last name plus first letter of first name plus 3 digits.
Example John Smith would be SMIJ000, then the next person say Jill Smith would be SMIJ001.
So it will pop up and say that is not unique, but I would rather have it in the calculation know that SMIJ000 is used and add 1 to the end and if that is used go to the next number..
This is replacing a database that is in place so it needs to be like this...