3 Replies Latest reply on Jul 16, 2014 6:02 AM by philmodjunk

    address calc using a a key from a list

    abunce515

      Title

      address calc using a a key from a list

      Post

           I am wanting to make an address calc field but my street and my state are pulled from a unrelated table.  The table populates the primary key instead of "street" or "Drive" - I do this so I can later change to abbreviations easily if I choose.  

           How do I get the calculation field to show "street" instead of "__pkstetyp000001" (obviously the primary key in the unrelated table)

            

           thank you.