3 Replies Latest reply on Mar 14, 2011 1:30 PM by jimlongo

    Substitute displayed value



      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.