Changing the value displayed in a layout based on value in a table
Hello, I am new to filemaker and either i'm not searching the internet with my question correctly or i'm finding the anser and not implementing correctly. Hopefully someone can help.
Note: All the data I have is read-only imported from DBASE.
I basically have a table that has text fields that show for example; "Y" for "Yes", "N" for "No", "G" for "Gallons",
How can I make a layout/report show the word "Yes", "No", "Gallons" or any other full word based on an abbreviation in the related field? Is this possible?