Results 1 to 2 of 2

Thread: Filter on a linked table field

  1. #1
    User
    Join Date
    04-01-10.
    Posts
    213

    Frage 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.
    Last edited by charled; 01/16/2014 at 15:35.

  2. #2
    User
    Join Date
    04-01-10.
    Posts
    213

    Default

    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.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •