AnsweredAssumed Answered

Trouble Writing an IF Statement using  3 tables

Question asked by artworking on Feb 8, 2015
Latest reply on Feb 11, 2015 by 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))
 
 
 
 

Outcomes