Hi all,
I have a grid search form where I have different field to select .
Some of these are interelated so for istance if I choose first the YEAR then I would like to show in another select field only the records with a WHERE clause on previous field.
I did a test but it do not works.
year_card_actual:
SELECT memberID, year_card_actual
FROM members
GROUP BY year_card_actual
ORDER BY year_card_actual
then I have a field that would like to select only members available for that select year_card_actual:
member_card:
SELECT memberID, sc_concat(member_card, " - " , contactLastName, " ", memberName)
FROM members
WHERE year_card_actual = {year_card_actual}
ORDER BY year_card_actual, contactLastName, memberName
The second member_card is always empty.
On search field there is no possibility to add an on_change variable like [year_card_actual] so I don’t know how to have the information of the year on second select.
Thanks
Giovannino
