AnsweredAssumed Answered

How do I write the proper calculation using "case" to link "city" and "region" contact information?

Question asked by kelpgriffin on Oct 18, 2012
Latest reply on Oct 19, 2012 by ErikWegweiser

I am about to import 10,000 contacts into my FMP 11 database. What will be the proper calculation to automate a link between "city" and "region" such that if "city" = San Antonio, "region" = San Antonio? I need to write a case calculation that includes hundreds of cities (not just "San Antonio"), which will link to only nine regions. How would I adjust the following calculation to include hundreds more cities?:

 

("Region" Field Calculation): Case ( City1 = "San Antonio" ; "San Antonio" )

 

Thanks!

Outcomes