Filtering and multi-selecting values

[tonyg88]

Hello All,

I'm looking for a way to select values and filter a set of values in a cell based on another value in a separate cell.

Example:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Type of Candy[/TD]
[TD]Subtype of Candy[/TD]
[/TR]
[TR]
[TD]Candy Bars[/TD]
[TD]Snickers, Milky Way[/TD]
[/TR]
[TR]
[TD]Candy Bars, Fruity Candy[/TD]
[TD]Snickers, Starburst[/TD]
[/TR]
</tbody>[/TABLE]

You are able to select one or more values in the first column and depending on what you select in the first column, the options that are shown for subtype of candy should be filtered. For example - if you select candy bars, you should only be able to see options for candy bars and not fruity candy. However, for both columns, you should be able to select multiple values easily and if more than one value is selected, they are separated by a comma.

I'm looking for help on this - have been trying to figure it out with no success. Let me know if this is clear - would greatly appreciate if someone can figure this out.