How to code a lookup function

[jared]

perhaps this will be helpful for you?

Performing a VLOOKUP in LocalDB

[print1] [print2] I solved it using the codes from the first image. Thus, when the student clicks on his name, he pulls the “current training” column on the same line as the name and shows the column items in the listviewer. BUT I used the “access filter” block so that when the person enters, only their name appears in the listviewer, preventing them from seeing someone else’s training. But that doesn’t work, because the variable “line” is always 1, which makes each person click on their own…

If you read through the thread it mentions how to do a lookup in airtable also.