Store selected Value from LookUp or DrillDown in Variable

mnewmedia
mnewmedia Member Posts: 13
edited 2013-10-10 in NAV Three Tier
Hi,

I would like to have Page where i have a variable which is a field with a DrillDown(Page Companies) and store the selected value in the variable.
Does somebody know how i can do that?

I only could get a LookUp work with this Code in the OnLookup Trigger 
IF PAGE.RUNMODAL(PAGE::Companies) = ACTION::LookupOK THEN
But then i still don't know how to store the selected value in the variable, it just stays empty...
mnewmedia
NAV 2009 R2
NAV 2013 R2

Comments

  • Kishorm
    Kishorm Member Posts: 921
    Create a variable for the company table and then pass as the second parameter in the RUNMODAL statement, the company table will then be positioned on the selected company record after the page has been closed.
  • mnewmedia
    mnewmedia Member Posts: 13
    Ok Thanks, it works now with this code: 
    IF PAGE.RUNMODAL(PAGE::Companies, CompaniesRec) = ACTION::LookupOK THEN BEGIN
   CompanyFrom := FORMAT(CompaniesRec);
END;
    But is this also possible as a DrillDown?
    mnewmedia
    NAV 2009 R2
    NAV 2013 R2
  • Kishorm
    Kishorm Member Posts: 921
    Yes it will, but with a drill down you would not normally select a record but only show a filtered list of items, so normally steps would be...

    1) Create a variable for the drilldown table
    2) Apply the appropriate filter on the drilldown table
    3) Create a variable for the form
    4) Set the LOOKUPMODE to false on the form
    5) use SETTABLEVIEW on the form passing in the table
    5) do a MyForm.RUNMODAL;

Categories