AnsweredAssumed Answered

how to lookup a table??

Question asked by theharrisonlee on Jun 1, 2016
Latest reply on Jun 2, 2016 by theharrisonlee

I have the account name by using

Get(Account Name)

 

I want to use this value to look into the table Staff,  and give me the Staff::authority_level by finding the Staff::staff_id that equals the account name.

 

Do the tables have to be related?

 

I really don't know what the functions i need in order to achieve this.

 

 

Many thanks

Outcomes