Filter on a linked table field

Hi everyone,

I got a table cat_seasons with 2 fields :
- season_label (text)
- inprogress (checkbox).

I got another table cat_events with :
- event_season - select linked to cat_season:season_label
- event_name

In a cat_events cataloglist module, how can I add the condition "only events linked to a season where inprogress = yes" ?

In other words, how can i follow the link between cat_events:season and cat_seasons:season_label to filter on another field from cat_seasons.

Thanks for your help.

Hello everyone,

A little up trying to simplify ma question.

Imagine two Catalog (cat_A and cat_B) are linked with a select field from Cat_B to cat_A.
In a cataloglist module to list cat_B records, is it possible to use a condition base on a cat_A field (like a checkbox checked or not, or some dates…)

Thanks for your answer.