Using check lists to retrieve data from a data master
I am trying to write an expression that will retrieve records from a data mater based on values selected in a check list widget. For example, each checkbox in a list represent colors: red, green, and blue. If the user selects the red and blue checkboxes I want to retrieve all items that are either red or blue. I am able to get it to work if only a single checkbox is chosen, but when multiple checkboxes are selected it doesn't work at all. It seems like if red and blue are chosen it is mapping it to a string "red,blue" and will only match a data master column that also happens to have the string "red,blue". Please advise.