MichelleL
8 months agoQrew Trainee
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 will select a category from a dropdown menu. I have another field that I need to auto-populate with the current contact (who will be a quickbase user) for that category. I have another table that stores the categories and current contact. I set up the relationship, but all my attempts to get the contact field in the main table to look up the category, find it in the second table, and return the relevant contact have failed.
Can someone point me in the direction of a simple explanation on how to do this? It'd be much appreciated.
------------------------------
Michelle L
------------------------------