FMP 12 Calculation Help
I am stumped. I have a value list of accommodation types that has 14 different text values - for example "Hostel" "Lodge" "Resort" etc. that I use in the field "accommodation type"
Now, I am going to be doing regular exports from this database but need to have this field exported as a numeric value - for example "Hostel" would be type id 1 and I need to have a field - call it "typed" that would have the numeral 1 in it if that particular entry had Hostel as the accommodation type the numeral 2 for Lodge, numeral 3 for resort, etc.