1 Reply Latest reply on Jun 17, 2010 6:28 AM by ryan

    In label layout have the "P.O. Box" field override the "Street field"

    lin_1

      Title

      In label layout have the "P.O. Box" field override the "Street field"

      Post

      I am using Filemaker 7 on a iMac with Snow Leopard. I have a mail label layout. Some addresses use a street address, some a P.O. Box. Some have a mailing address in a different town than their residence. (Weird rural system.) Is there a way to have the residential address ignored if there is data in a P.O. Box field or a Mail address field? I'd like to avoid creating a field that duplicates the residential address.

      THanks.

        • 1. Re: In label layout have the "P.O. Box" field override the "Street field"
          ryan

          Create a Calculation field, which i'll call Address_Label in the post, and use the CASE Function.

           

          Address_Lable =

           

          Case (

           

          not IsEmpty ( POBoxField ) ; POBoxField ;

           

          not IsEmpty ( MailAddressField ) ; MailAddressField ;

           

          ResidentialAddressField

           

          )

           

          If i understand correctly the Hierarchy of the address system, This will use the POBox field firstly if it contains data, if not it will look at the Mail Address field and use it if it contains data, if neither have data it will use the Residential address.

           

          So just make sure you use the new calculated address field on your label layout.