hello ,
I want to add lookup in line details(accounts receivable> sales order >all sales order)
this lookup displays data from cutomized table only for the current customer :
this is the table :
I add new stringEdit control and i add this code in OnLookup event handler :
[FormControlEventHandler(formControlStr(SalesTable, INTGroupingCode), FormControlEventType::Lookup)] public static void INTGroupingCode_OnLookup(FormControl sender, FormControlEventArgs e) { Query query = new Query(); SalesTable salesTable = sender.formRun().dataSource("SalesTable").cursor(); QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; SysTableLookup sysTableLookup; sysTableLookup = SysTableLookup::newParameters(tableNum(INTGroupingCodeTable),sender); queryBuildDataSource = query.addDataSource(tableNum(INTGroupingCodeTable)); queryBuildRange = queryBuildDataSource.addRange(fieldNum(INTGroupingCodeTable,CustomerAccount)); queryBuildRange.value(queryValue(salesTable.custAccount)); sysTableLookup.addLookupField(fieldNum(INTGroupingCodeTable,GroupingCode ),true); sysTableLookup.addLookupField(fieldNum(INTGroupingCodeTable, Description),true); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); }
but I can't display data.