2 Replies Latest reply on Jan 5, 2010 12:09 AM by russcb

    Print one field value or another if null

    russcb

      Title

      Print one field value or another if null

      Post

      As a newbie I have inherited some problems, however, I'm working my way through them as I do not want to re-invent the wheel.

       

      Our Table contains "Street" address field as well as a "PostalAddr" field for a postal address if it differs from the "Street" address.

      I am looking for a script to put in the label Layout so it will show/print the "Street" field or the "PostalAddr" field if it has contents.

       

      Can this be done if so how? Using FMP Ver 7 on XP SP3.

       

      Any help would be appreciated.