Search in 2 columns Based on 1 ListBox selection

[#1]

I have the following records

Rolling 12 Month	Rolling 6 Month	Topic
1	1	Topic 1
1	1	Topic 2
1	0	Topic 3
1	0	Topic 4
0	0	Topic 5

Also I have a Inline data table:

Load * INLINE [

     DateRange

     Rolling 6 Month

     Rolling 12 Month

];

Now I Create ListBox for DateRange and I'd like to make the Topic selection based on this ListBox selection

[maxgro]

I suppose that you can use field events trigger, see attachment

In the menu go to Settings --> Document Properties --> Triggers and on Field Event Triggers choose the field (the one of the listbox) DateRange, then OnSelect --> Add Action(s)

in Windoww Actions add 2 Actions

Select in Field          [Rolling 6 Month]          =if(GetFieldSelections(DateRange)='Rolling 6 Month', 1)

Select in Field          [Rolling 12 Month]          =if(GetFieldSelections(DateRange)='Rolling 12 Month', 1)

[#3]

Thanks. But It's not working in case when dataset can't find any record. It just doesn't do anything

[maxgro]

just another attempt with a different approach