Conditional Dropdown to MultiSelect

Question

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------------------------------

chayceduncan · Answer

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 · Answer

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

markshnier__you · Answer

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
------------------------------

ericfixler1 · Answer

Thanks&nbsp; The solution works.------------------------------Eric FixlerEFC------------------------------

Forum Discussion

Conditional Dropdown to MultiSelect