unique number from diferent fields for client id
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.
|0||1||(type of client)|
|0||0||1||(client buisnes id)|