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 ...
Forum Discussion
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
------------------------------
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
------------------------------
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
------------------------------Thanks The solution works.
------------------------------
Eric Fixler
EFC
------------------------------
