Discussions

Expand all | Collapse all

Design Question with Conditional Dropdowns

  • 1.  Design Question with Conditional Dropdowns

    Posted 10-25-2019 18:59
    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 options, say Options 1-5.
    Each option has a number of labor positions associated with it, and each labor position has a specific rate.

    I would like to create an invoice and be able to do the following.
    Pick a project type. Then pick an option. That will populate the labor positions and I can just choose one. This I've accomplished using cascading dropdowns.

    However, I don't want to be limited to picking just one labor position. I want to have say 10 fields where I can keep choosing additional labor positions (as I pick the labor position, the rate can be populated from a lookup field. This rate is really what I need for future calculations).

    I suspect I am one table short, and need to create a many to many relationship somewhere in here, but I can't wrap my head around it. Or maybe there is a much more elegant solution I am not thinking of?

    Thanks for any help!

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Design Question with Conditional Dropdowns

    Posted 10-25-2019 19:08
    Yes, 
    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
    ------------------------------



  • 3.  RE: Design Question with Conditional Dropdowns

    Posted 10-26-2019 12:39
    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
    ------------------------------



  • 4.  RE: Design Question with Conditional Dropdowns

    Posted 10-27-2019 15:47
    Well, 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
    ------------------------------