1 Reply Latest reply on Feb 18, 2014 6:31 AM by philmodjunk

    combining 3 fields into 1

    metinzincirkiran

      Title

      combining 3 fields into 1

      Post

           hi there,

           I am trying to combine 3 fields together.

           sample;

           door no, street address, post code-----> long property address (it should contain data from 3 fields, than I can use for look up lists)

           if you can help, I will be grateful...

        • 1. Re: combining 3 fields into 1
          philmodjunk

               Option 1:

               Define a calculation field or a text field with an auto-entered calculation: door No Field & ", " & Street Address Field & ", " & PostCode Field

               Option 2:

               Substitute ( List ( door no; street address; post code ) ; ¶ ; ", " )

               Option 3:

               on your layout set up the three as merge fields in a text object:

               <<door no. field>>, <<street address field>>, <<Post code field>>

               

                    (it should contain data from 3 fields, than I can use for look up lists

               That might be problematic to do as small variations in how the address is entered (avenue instead of street, for example) could keep a given address from looking up the correct data.