AnsweredAssumed Answered

how do I substitute text strings for numeric field values?

Question asked by thilleary on Feb 16, 2018
Latest reply on Feb 16, 2018 by bigtom

New to FM. I have a huge table of data with fields containing numeric values (e.g. 1="Yes", 2= "No" in one field , or 0="Two Lanes", 1="Four Lanes", 2="Six Lanes" in another field).

 

I currently view the data in a table form, but want the fields to display the text in an understandable form (e.g. "Yes" rather than "1" ). What is the best way to do this?

 

It would also be nice to to be able to set up Finds using the text values rather than the numeric field values (e.g. looking for all records that are "Four Lanes" rather than "1" in that particular field.

 

Is GetField the best function?

Outcomes