Announcement

Collapse
No announcement yet.

Select filtered on previous selected field

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Select filtered on previous selected field

    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
    Attached Files
Working...
X