Lookup fields won't update
I have two cascading dropdowns that select Main Category (13 possibilities) and Sub Category (one to a dozen possibilities depending on the Main Category Selection). There are two (actually four, but...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendi'm not sure that I totally understand your relationships, but let me guess at an answer.
When you select a main category to then drive the filters for the next level of selection of Sub category, you should rename that like [Main category filter], as opposed to [Main Category]. Then use a lookup to get the [Main Category] as a lookup from the Inventory record. Same with the Sub Category.
The point is that if you Change the Main category from the Master Inventory record, you want tho flow down though the lookups. So differentiate between the data entry filter you are using and the live lookup values which may change if the master changes.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
When you select a main category to then drive the filters for the next level of selection of Sub category, you should rename that like [Main category filter], as opposed to [Main Category]. Then use a lookup to get the [Main Category] as a lookup from the Inventory record. Same with the Sub Category.
The point is that if you Change the Main category from the Master Inventory record, you want tho flow down though the lookups. So differentiate between the data entry filter you are using and the live lookup values which may change if the master changes.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
