Get Form Element Value for WHERE clause to filter result

[mikeb24]

Hi

i have a dropdown element with values like "categorie a", "categorie b", "categorie c", and so on.

the next element is from type database join and should only show values filtered by the dropdown.

the table looks like id, categorie, value --- 1,a,100 2,b,50 3,b,51 3,c,30

if categorie b ist selected only the values 50 and 51 are in the list

thx for help

 

[mikeb24]

my WHERE clause so far:

WHERE categorie= dropdown categorie value

 

[troester]

I assume you are looking for the cascading drop down element.
http://fabrikar.com/forums/index.php?wiki/cascading-dropdown-element/

 

[mikeb24]

so simpel ... thx