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(); }