Skip to main content
Question

Conditional Dropdown to MultiSelect

  • March 28, 2024
  • 0 replies
  • 393 views
Forum|alt.badge.img+4

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
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • March 28, 2024

    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
    ------------------------------
    Terms & ConditionsAccessibility statement