AnsweredAssumed Answered

imported data into a field with a value list...

Question asked by GeoffreyMartin3300 on Dec 28, 2011
Latest reply on Dec 29, 2011 by philmodjunk

Title

imported data into a field with a value list...

Post

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?

 

An example:

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.

Thanks!!

-Geoff

Outcomes