AnsweredAssumed Answered

Hi, looking for the help: Table A is a employee list: company, username; one company...

Question asked by ShineSh on Aug 29, 2014
Latest reply on Aug 30, 2014 by ShineSh

Post

     Hi, looking for the help:    

Table A is a employee list:   company, username;  

     one company has several employees;   and table including several companies as well.

     for better understanding, I attach the example as attached jpg.

     if the accountname="tom"  

     how to show all employees of "A" company which tom is in? 

     I try to set a parameter $$companyname  by {   if(A.username=get(AccountName);A.company;"") }, and run query($$username), but does't work.     

     where I'm wrong?   Thanks a lot!

      

      

      

      

      

question.jpg

Outcomes