AnsweredAssumed Answered

unique number from diferent fields for client id

Question asked by RafaelRassam on Jul 28, 2011
Latest reply on Jul 28, 2011 by philmodjunk

Title

unique number from diferent fields for client id

Post

Hi:

I'm New to FileMaker, and needed to create a unique number to identify different clients. I need a 17 digit number, the first 2 digits are letters the next to have to be generated from a pull-down menu, the next two digits are from another menu and so on , i think this diagram explains the structure of the number better. This number cannot be repeated it must be unique. we have over 1,000 small clients. the last 6 digits should be generated automatically for every client.

I would greatly appreciate if someone could help me or if they have a solution for this.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17


























M H
(client inicials)



0 1
(zone)







0 1
(type of client)









0 1
(MATERIALS)









0 0 1
(client buisnes id)













0 0 0 0 0 1
(sequential)

Outcomes