9 Replies Latest reply on Feb 11, 2015 12:02 PM by artworking

    Trouble Writing an IF Statement using  3 tables

    artworking

      Title

      Trouble Writing an IF Statement using  3 tables

      Post

      I would like to inbed a calculation IF the address is related to Clients 2 then I would like to see Clients 2 & Address, If the address is related to Galleries then give me the Gallery and address. How would I write it? 

       

      If ( C_Address; Clients 2::C_FullName  &  ¶  & C_Address; If ( C_Address; Gallery 4::Gallery & ¶ & C_Address))