Is it possible to use a PICKed one record as the comparator for another PICK query....
For example......
I have BOs Country and child many LeaveType
I want the user to PICK and Country and then PICK a LeaveType of That Country
If I use following...
I pass the current selected Country to a Process which will be ThisCountry.
PICK Country FROM 'Pick Countries query'
Which should allow the user to PICK any Country OTHER than ThisCountry
So, in Query I expected Country <> ThisCountry
Unfortunately All Countries are shown rather than All EXCEPT ThisCountry
Then, assuming the user selects a Country which will become ThatCountry
PICK FROM 'Country Leave Types Query'
and the query is
LeaveType.Country = ThatCountry
Also does not work.
Seems the Queries have no idea what Countries are in context either This or That
Am I approaching this the wrong way?
