Display Form: ListBoxes - Multiple Values for following where clauses

Hi all,

 

 

I have a request to allow multiple values to be selected in a form, which helps populate values in the cascading list boxes.. There are 4 list boxes that are populated based on what the user selects from the previous list box value(s). It is no problem if I allow them to select just one value, and then use the cascade id to allow a where clause like: ORG_CD = '{1:ListBox1}' AND SALE_FY = '{1:ListBox2}'

 

 

But, if I let them choose multiple/extended values, I can't seem to get a proper query to work, and I am wondering if that is even possible. For example, I've tried:

 

ORG_CD = '{1:ListBox1}' AND SALE_FY IN '{1:ListBox2}'

 

ORG_CD = '{1:ListBox1}' AND (SALE_FY = '{1:ListBox2}' OR SALE_FY = '{0:ListBox2}')

 

# I am not sure what the 0 or 1 represents that precedes the ListBox number.

 

 

This probably is not possible, but thought I'd ask. I know how to do this with multiple menus, but I'd rather not use 5 menus when I could use just one.

 

 

Thanks!