Multiple Choice List column use as Filter in InfoPath

BejeweledOne — Fri, 01 May 2015 13:42:10 GMT

I am not sure if this can be done easily or at all, but here goes.

I have a form for requesting phones. The phone choice are made from a dropdown list that displays a list of choices based on the carrier that they are associated with. Currently I have individual entries for each phone with a carrier in the list. So it would look like this:

iPhone 6 AT&T

iPhone 6 Verizon

Samsung Galaxy S5 AT&T

Samsung Galaxy S5 Verizon

On the form the user chooses a carrier from a list and then the dropdown of phones is filtered based on the carrier selection in the list. So it only shows phones associated with the selected carrier. Unfortunately this makes my list very long. I would like to be able to make the carrier selection in the list a multiple choice field so I can have only a single entry for each phone, looking something like this:

iPhone 6 AT&T, Verizon

Samsung Galaxy S5 AT&T, Verizon

My issue is if I do this how would I accomplish the filtering. I have tried a couple ways using a 'contains' but that doesn't seem to work. I would like to be able to filter the dropdown to show only those items where the carrier (list column) contains the selected carrier (form field). Is this possible without code?

Browser Forms

Multiple Choice List column use as Filter in InfoPath