help about cascade dropdown with sql data

Hello,
I'm trying to create two depending cascade dropdown in my project but it doesn't' work.
The situation is:

FieldA (type dropdown)
in "value" tab I set "use sql" with this query "select tab1_id as value, tab1_name as text from table1"
master field is set on "NO"

FieldB (type dropdown)
in "value" tab I set "use sql" with this query "select tab2_id as value, tab2_name as text from table2 where tab2_id_tab1 = 'masterValue'"
master field is set on "fieldA"

but when I select an item on field A the fieldB remains empty. Please help me!!!

Thank you

you can't do this with sql i think
you can do this with raw value and master field option

Hello,

I don't understand,
the component not supports the cascade dropdown based on sql? Or I've to set the "use SQL" to no in fieldA and insert the sql sintax in the raw editor?

But in this case, can you explain me the right syntax to create a sql string regognizable by the second dropdown?

thank you

I've found this video tutorial ( vimeo.com/174007364 ) that uses sql instructions for the dropdowns, I've nomalized my sql with these examples, in detail:

Drop1:
select tab1_id as value, tab1_name as text from table1

Drop2:
select tab2_id as value, tab2_name as text, tab2_id_tab1 as valgrp from table2

But the second dropdown show all the table field (no filtering)...but why???

Please help me

at first trhanks for video
second i think you forgot where condition in your valgrup

Yes, I want to put the where statement....but the corrent sitax?

in the second dropdown query I've to write
select tab2_id as value, tab2_name as text, tab2_id_tab1 as valgrp from table2 where valgrp = #TO_WHAT?#

Suggestions?

thank you