Cascaded dropdown filter

[c,bacchi]

Hi,
I have a table with fields "car", "car model", "fuel", "displacement", "battery model."
I created a list with filters for "car", "car model", "fuel" and "displacement". Is it possible that the filters are cascaded dropdown?

Is it possible that, when I select the "car", in the "model car" there are only models of the "car" selected?



Kind regards

 

[c,bacchi]

?

 

[cheesegrits]

They couldn't be CDD's, as that would require the field's themselves to be CDD's, and the data to be normalized into separate tables, which wouldn't really make sense in your case.

I can't really think of any way of doing this.

Anyone else got any ideas?

-- hugh

 

[cheesegrits]

I think the only way you could do this would be to have 'cars' and 'car models' as separate tables, and the list you are filtering as third (car_details or whatever). Then on car_details, your 'car' element is a join to the 'cars' table, and 'models' is a CDD to the 'models' table.

But I'm open to suggestions from anyone ...

-- hugh

 

[mhas16]

I have the same requirement. It's sad to know that it can't be done directly. I hope it will be considered in future updates.