Design Question with Conditional Dropdowns
I may be going about this the wrong way and need to start from scratch, but I am not sure. I have many projects types, let's call them Project Type 1-10. Each project type can have a number of op...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYes,
You should add a Child table called Job Labour Positions. It can still operate as a conditional drop down based on a lookup of the Project Type Option.
One Project has Many Project Labor Positions. One Labor Position has Many Project Labor Positions.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
You should add a Child table called Job Labour Positions. It can still operate as a conditional drop down based on a lookup of the Project Type Option.
One Project has Many Project Labor Positions. One Labor Position has Many Project Labor Positions.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- Perfect thanks! One thing - I'm passing the related project type to the project labor position child table via a lookup. However it passes the record ID#, and when I use the conditional dropdown I think it is looking at the actual number instead of the text field i need to use for the lookup? I'm thinking i need to recreate the relationship and use the text field as my primary key? Is that the best way?
------------------------------
Mike Tamoush
------------------------------- MarkShnier__YouWell, you can either match up the Numeric Related Related project Type to the [Record ID#] of the Project type or you can also lookup the Text name of the Project Type and use that to match on the Project Type words.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
