Hi everyone,
Let’s say I am in a subform and the cursor is pointing to a certain record.
I am using certain fields of the current record (val 1 & val 2) to filter in RecXXX and run another page based on it.
RecXXX.SETRANGE(field1,val1);
RecXXX..SETRANGE(field2,val2);
PageXXX.SETTABLEVIEW(RecXXX.);
PageXXX.LOOKUPMODE := TRUE;
PageXXX.RUNMODAL;
Now, I need in addition to filter on another value (val3) and make the page start first with the record RecXXX that has val1, val2 and val3.
How can I achieve that?
Thanks in advance 