Create a unique alpha numeric code
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?