Store selected Value from LookUp or DrillDown in Variable

mnewmedia

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...

Kishorm

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

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?

Kishorm

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;