Inputscreen : select attribute filtered based on another select attribute
Hello,
I still got my 3 MM : mm_Seasons, mm_Events and mm_Meetings. mm_Meetings is linked to mm_Events (many meetings for one event) and both mm_Meetings and mm_Events are linked to the same text attribute in mm_Seasons.
In mm_Meetings, I got 2 select attributes : linkToSeason (linked to mm_Season.Name) and linkToEvent (linked to mm_Event.Name). In my inputscreen, I just need linkToEvent list to be filtered based on witch season is first selected in linkToSeason. Something like "select the mm_Events records where mm_Events.linkToSeason = the actual mm_Meetings.linkToSeason.
I've created a filter in mm_Events and trying to write the right sql filter but the best result I got is a blank list (-) when not an error.
Thanks for your help.