Generating dealer number via calculation field
I'm a relatively new user of FIlemaker Pro 11 on my mac running OS X.
I'm trying to calculate a dealer number based off of 2 tables and a serial number generated on the creation of a new record. The other 2 parts are generated by seperate related tables with the Region_Name and Store_type ( i.e boutique, speciality shop, etc.) and the codes associated to these items. I have the region/ type selectable on a drop down menu from the application layout ( where i would like the dealer number to be generated) and i can't seem to find a way to hv the calculation field associate the selected values with their code counterpoints and therefore generate the dealer number as the data is being commited.
Thanks for any help in advance.