Hey Jamie, I was a little slower than usual in getting to this one.
Thx for the complete explanation of your tables and their relationships.
You will be happy to hear I think that this is trivial.
There is a feature in Quick Base we can a Conditional Drop Down (CDD).
On the Relationship between Auditors and Audits, bring down the Audit Role and then from there hop it down as another lookup down to Audit Findings, and then another hop all the way down to so that it shows on the Question form.
Then you should be able to look at the Related Question Master Table (you did not describe that table exactly, and look for the checkbox on the reference field for the relationship where the Questions come from called
Conditional values The values in this field depend on a selection in another field
You should be able to select Audit Role to match on.
... anyways the answer will be to get a CDD working and to coax what you need to match on into the setup for
Conditional values The values in this field depend on a selection in another field------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
