Make a page start on a certain record

poppinspoppins Member Posts: 647
edited 2015-08-18 in NAV Three Tier
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 :mrgreen:

Comments

  • krikikriki Member, Moderator Posts: 9,094
    Before the SETTABLEVIEW, try to set the primary key-fields of the record you want to show.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • jreynoldsjreynolds Member Posts: 175
    Use PageXXX.SETRECORD.
Sign In or Register to comment.