Substitute displayed value
Hi, this is probably a pretty simple question, I just can't find the answer.
I have a field for whether or not a telephone number should be published. It comes from a mysql database and is 0 for Yes, and 1 for No. I would like my FMPro database to display √ if it is 0, and x if it is 1.
That's easy enough.
BUt I don't want the actual value in the database to change, I just want the display to change.
I've tried various calculations but they always end up changing the actual field data.