First time posting here and hoping someone has a solution. I have the following lists:
List A – my main site. Relevant fields in this list are Primary Tier 3 Domain, Secondary Tier 3 Domain, Primary Strategy, and Secondary Strategy with lookups to the following lists:
Domain – contains fields: ID, Tier2, Tier 3 (no lookups to other lists)
Strategy – contains fields: ID, Title, Tier 2 (no lookups to other lists)
I have added 2 data sources: one for the Domain Fields and one for the strategy fields
I have an InfoPath 2013 form where I need 2 sets of cascading drop down fields. The first dropdown is a single select dropdown (Primary Tier 3 domain). I have a rule to set a helper field (text field) that is used to filter the Primary Strategy field. This field is working correctly.
I’m having trouble figuring out how to filter the Secondary Strategy field when multiple items are selected in the Secondary Tier 3 domain field which is a multiple select dropdown. The user needs to be able to select various filtered results in the Secondary Strategy field based on what is selected in Secondary Tier 3 field.
Is there a way to filter from a multiple select dropdown list? I’ve scoured every resource and am tearing my hair out…
Can someone please explain how to accomplish filtered results from a multi-select field? I need to have the form in InfoPath 2013 and if coding is required, I need specific instructions. Thank you!