Hi Martin Dráb
I use you link to download SysMultiTableLookup and write the following code in lookup of my field
//super()
Query query = new Query();
QueryBuildDataSource qbdsInventSum;
QueryBuildDataSource qbdsInventDim;
QueryBuildDataSource qbdsInventItemLocation;
QueryBuildRange qbrModuleType;
SysMultiTableLookup sysTableLookup;
;
qbdsInventSum = query.addDataSource(tableNum(InventSum));
qbdsInventSum.addRange(fieldnum(InventSum, ItemId)).value(queryValue(ItemId.text()));
qbdsInventSum.addRange(fieldNum(InventSum, Closed)).value(queryValue(NoYes::No));
/*qbdsInventSum.addGroupByField(fieldnum(InventSum, ItemId));
qbdsInventSum.addSelectionField(fieldNum(InventSum, ReservPhysical), SelectionField::Sum);
qbdsInventSum.addSelectionField(fieldNum(InventSum, OnOrder), SelectionField::Sum);*/
qbdsInventDim = qbdsInventSum.addDataSource(tableNum(InventDim));
qbdsInventDim.relations(true);
qbdsInventDim.addLink(fieldNum(InventSum, InventDimId), fieldNum(InventDim, InventDimId));
qbdsInventDim.joinMode(joinMode::InnerJoin);
qbdsInventDim.addRange(fieldnum(InventDim, InventSiteId)).value(queryValue(Site.text()));
qbdsInventDim.addRange(fieldnum(InventDim, InventlocationId)).value(queryValue(WareHouse.text()));
sysTableLookup = SysMultiTableLookup::newParameters(this, query);
sysTableLookup.addLookupfield(fieldnum(InventDim, ConfigId), 2);
sysTableLookup.addLookupfield(fieldnum(InventSum, ReservPhysical), 1);
SysTableLookup.addLookupMethod(tableMethodStr(InventSum, PhysicalInvent),1,"Physical Invent");
sysTableLookup.addLookupMethod(tableMethodStr(InventSum, orderedSum), 1, "Ordered Sum");
sysTableLookup.addLookupMethod(tablemethodstr(InventSum, AvailOrdered), 1,"Avail Ordered");
sysTableLookup.addLookupfield(fieldnum(InventSum, OnOrder), 1);
sysTableLookup.performFormLookup();
