QB equivalent of VLOOKUP
I can't for the life of me figure out what I'm doing wrong here, as I know I've made it work before, in forms/tables that no longer exist, sadly.
I have a table filled out via a form. The user wil...
Forum Discussion
Sounds like you just need a simple relationship, with a lookup field. I am presuming one table (lets call it category table) has records that look something like:
Category A, User Jon Smith
Category B, User Jane Doe
Category C, User Julie Baker
On the other table (main table), you want to select category B, and it show Jane Doe right?
If so, make a relationship, one Category Table has many Main Tables.
Proxy field is the Category, then you make a lookup field of the User. Simply display the user field on the Main table.
------------------------------
Mike Tamoush
------------------------------
I finally got it to work! Thank you so much. Ridiculously simple once you figure it out.
------------------------------
Michelle L
------------------------------
