Forum Discussion

MatthewMatthew2's avatar
MatthewMatthew2
Qrew Trainee
13 years ago

Formula to look up a corresponding field from a related table?

I'm a new QuickBase user. This is probably a simple question, but I don't know how to construct a formula to look up a corresponding field from a related table. I have a parent table and a child t...
Account and realm management
Forms
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I don't really know of the full scope of your app, so you would have to decide, but if there are just a few fields that you need from the VIN table, then the Sync table would allow that to happen without changing "all your other" relationships.  I don't know how many relationships would need to be redone.
KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
8 years ago
Well now I'm thinking I may just go back to the record picker. I don't like it, but you can search by partial numbers.