Make dropdown list with two columns In Form D365 [Override Lookup method]

1- add any string field in the form

2- copy “OnLookup” event handler

3- add blew code on event handler method

[FormControlEventHandler(formControlStr(smmOpportunityTable, smmOpportunityTable_BiScenario), FormControlEventType::Lookup)]
public static void smmOpportunityTable_BiScenario_OnLookup(FormControl sender, FormControlEventArgs e)
{

    QueryBuildDataSource queryBuildDataSource;
    QueryBuildRange queryBuildRange;
    SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(BiScenarioTable), sender);
    Query query = new Query();



    sysTableLookup.addLookupfield(fieldNum(BiScenarioTable, BiScenario));
    sysTableLookup.addLookupfield(fieldNum(BiScenarioTable, SenarioDesc));



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



    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();


}

Leave Comment

Your email address will not be published. Required fields are marked *