Related table column value in Behavior-Set Column Values

[BobG]

I have 3 tables; Techs, Work Tickets & W/T Log. When a Tech checks into a Work Ticket on main table it is copied to the Log table. I can get the useremail to show on the Log but can’t figure out how to get the Tech’s name to fill the Tech Name column of the Log. The Tech’s Email is the key for the Tech table.

[hru · Accepted solution]

Maybe LOOKUP? for the initial value of tech name column of the Log Table, like:

LOOKUP(USEREMAIL(), “Techs”, “Tech’s Email”,“Tech Name”)

[BobG]

Thanks Heru. It works perfect