Referencing the name with the same Email as Useremail used

[paula]

Hello everyone!

I have two tables here. In the first table "Form" I want the column PREPARED BY to display the second table's (Sales Person) NAME corresponding to the Email (which is equal to the Useremail logged in). How can I do that?

Thank you so much in advance!

[TeeSee1 · Accepted solution]

Set Sales Person[Name] as label while Sales Person[Email] is the key.

Set Form[Prepared By] as a ref to the table Sales Person.

[paula]

Thank you so much for that quick help!