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
I don't think you need to make the category the key field. If the user is manually selecting, then they simply select the category they want. What you are looking for is a lookup field. Once they select the category, any of the information attached to that category can be pulled into the main table via lookup fields.
------------------------------
Mike Tamoush
------------------------------