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