Three Dropdown filter

[confis]

Hi,

I have three drop down elements in the form

all of them are join from different tables, but foreign key connected them

I would like to filter the dropdown based on the upper dropdown selection

for example
user select dropdownOne_data01 from dropdown one

dropdownOne_data01
dropdownOne_data02
dropdownOne_data03
etc,

At dropdown two user will see only the data how connect to dropdownOne_data01
dropdownOne_data01 > dropdownTwo_data08
dropdownOne_data01 > dropdownTwo_data07
dropdownOne_data01 > dropdownTwo_data06
etc,

user select dropdownTwo_data07 from dropdown two

At dropdown three user will see only the data how connect to dropdownTwo_data07

dropdownTwo_data07 > dropdownThree_data01
dropdownTwo_data07 > dropdownThree_data02
dropdownTwo_data07 > dropdownThree_data03
etc,

you can see it at

http://superdial.me/service-provider-rating.html

Please help me with this.

 

[troester]

You'll need one dbjoin element and 2 cascading dropdown elements.
See
http://fabrikar.com/forums/index.php?wiki/cascading-dropdown-element/
http://www.fabrikar.com/forums/index.php?threads/cascading-dropdown-3-levels.36588/#post-184366