Create lookup in D365FO using X++

Create lookup in D365FO using X++

·         Open the form

·         Go to the form string control on which you want to show lookup

·         Go to the events of the form string control on forms

·         Right click the OnLookup event and click Copy event handler method

·         Create a new class and paste the event handler method in the class you have copied in the previous step

[FormControlEventHandler(formControlStr(Form, AccountNum), FormControlEventType::Lookup)]

public static void AccountNum_OnLookup(FormControl sender, FormControlEventArgs e)

{         

     //Add the lookup logic here.

}

·         Add the logic of the lookup in the event handler method like below:

[FormControlEventHandler(formControlStr(Form, AccountNum), FormControlEventType::Lookup)]

public static void AccountNum_OnLookup(FormControl sender, FormControlEventArgs e)

{  

        Query query = new Query();

        QueryBuildDataSource queryBuildDataSource;

        QueryBuildRange queryBuildRange;

   

        SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(custTable), sender);

   

        sysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));

        sysTableLookup.addLookupField(fieldNum(CustTable, CustGroup));

   

        queryBuildDataSource = query.addDataSource(tableNum(CustTable));

   

        queryBuildRange = queryBuildDataSource.addRange(fieldNum(CustTable, CustGroup));

        queryBuildRange.value('40');

   

        sysTableLookup.parmQuery(query);

   

        sysTableLookup.performFormLookup();

   

     

    

}