I have two fields in my QVW named Period and MeasureMonth...I need to add two actions to trigger upon open, one needs to select the Period 'YTD' and the other needs to select the max month within MeasureMonth.
Everything I try seems to fail and I think the reason is because the two fields are on separate tables. Can anyone suggest anything?
At the moment, the trigger only ever sets one of the values.
