AnsweredAssumed Answered

Create a unique alpha numeric code

Question asked by Pam on Jun 23, 2010
Latest reply on Jun 23, 2010 by LaRetta_1

Title

Create a unique alpha numeric code

Post

I am a novice user of Filemaker Pro v10 (MAC), with limited script writing ability.

 

Is there a way to create a unique customer ID code. To be based on the first 3 letters of the surname and the 3 digits (commencing 001). When one inputs the letters, the next number in the sequence should be added.

If it is not possible to automate the function, how would one show the options already used, so that the user can manually create the next sequence?

Outcomes