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
So the Category table has a relationship to the primary table, in that relationship is where you would pull the contact field through. How are you trying to add the contact field in the primary table?
------------------------------
Josh Hamilton
------------------------------
Hi!
So I have the table relationship set up (one contact to many primary table records) and set the category field (in the category table) as the key field. That relationship field is showing up in my main table, but I'm at a loss as to how to get the contact field in the main table to pull the contact from the contacts table based on the corresponding category. I've tried and abandoned a whole lot of formulas and attempts to get the info using Pipelines, and am having no luck at all. I swear I've done this successfully in the past and it was simple. I'm definitely missing something obvious, but I've no idea what.
------------------------------
Michelle L
------------------------------
