what to do when you cant "filter" the dataset like the sample

I have an issue, I cant filter the dataset the way that the instructions say to.

I have select1 populated from select1datatable
fields are select1ID and select1color
Records are:
1 Blue
2 Green
3 Red
4 Brown

I have select2 populated from select2datatable
fields are select2id select2size and 4 checkboxes named Blue Green Red Brown
Records are like this
1 Small 1 0 1 1
2 Large 0 1 0 1
3 Medium 1 0 0 1
4 XLarge 0 0 0 1

What i need to have it do is if BLUE is selected from select1, i need it to filter select2 for the records where blue is checked.

any way to manipulate this to work with this extension?
thanks

sam

Dynamic dropdowns will only work with dropdown lists, where you are using checkboxes for the colors, this will not work


depending on how data is stored in the database, you could create a select list for the color, then return the sizes that are available in that color.