Forum Discussion

EricFixler1's avatar
EricFixler1
Qrew Trainee
31 days ago

Conditional Dropdown to MultiSelect

I am trying to setup a structure where you have a Co-Name, Type and Subtype (3 connected tables) I have the relationships setup where the following works.

Each co has one type

each type can have one subtype

Subtypes are conditional on the type selected.

Is there a method to allow the subtypes to be a multiselect option?

I would prefer to have each of thes in a separate table for ease of management of the data

Thank you.



------------------------------
Eric Fixler
------------------------------

4 Replies

Sort By
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    31 days ago

    In the way your describe its unfortunately not possible to do a conditional multi-select like that. If you have a 'theoretical max' on the number of subtypes they can pick, you could just have multiple relationships to 'subtypes' where you have subtype (1), (2), (3) .... and users just pick each that's applicable and then for reporting you could merge them into a formula-multiselect. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    • EricFixler1's avatar
      EricFixler1
      Qrew Trainee
      31 days ago

      Thank you,

      Are you suggesting that I recreate the original relationship multiple times?  How then do I force the lookup to Type be consistent in the secondary relationship?  I need the type to be a single entry and that is used in the first and second relationship.



      ------------------------------
      Eric Fixler
      EFC
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew #1 Challenger
        31 days ago

        Tag teaming w/Chayce .. yes exactly, you can use the same selection of Type to drive all subsequent CDDs for SubTypes..



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------