AnsweredAssumed Answered

Unique in field

Question asked by Christic on Aug 8, 2014
Latest reply on Aug 10, 2014 by Christic

Title

Unique in field

Post

     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...

      

     Any ideas?

Outcomes