imported data into a field with a value list...
I have data that is imported into FM from another source. There is a 3 letter code that is imported in. I have a value list on that field that had the 3 letter code and a little more information. Is it possible to create a calculation that would populate the field with the value in the list that matches the imported data?
From import: Location_Responding_From = 4MO
Value List entry "4MO-Hwy4 and Morello"
It's a long list and I used to have to enter it by hand, but the database manager of the source data finally allowed it to come over in the report I'm importing.