Sorting from Two Drop downs
I am wondering if someone might have an example of multiple finds using multiple drop down menus. The TO has a record list with two categories one being "Type" and the Second being "Color", I want the user to be able to pick from the sort list key and pick from the "Type" = Dry, Sweet, Bitter etc and then filter further with the second drop down "Color". Red, White, Rose
I have been able to get the first drop down to find by "Type" but have not been successful in constraining the found set when the second drop down is selected. Each record has its own field defined by type and color
Thank you for direction.