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
------------------------------
- EricFixler112 months agoQrew Trainee
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__You12 months ago
Qrew Legend
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
------------------------------- EricFixler112 months agoQrew Trainee
Thanks The solution works.
------------------------------
Eric Fixler
EFC
------------------------------