Hi ,
There is a requirement on form along with ItemId name should display which is InventTable name() method.
for that i have written a lookup on form fields as below…but i am not getting desired out put because the use of name method. while itemid selection its throwing an error “Type void is not supported in this type of lookups” ,
any suggestion will be appreciated.
public void lookup()
{
//super();
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventTable), this);
sysTableLookup.addLookupField(fieldNum(InventTable, ItemId),true);
sysTableLookup.addLookupMethod(‘name’);
sysTableLookup.addLookupfield(fieldNum(InventTable,ItemType),true);
sysTableLookup.addLookupfield(fieldNum(InventTable,rmsInsurancePercentage),true);
queryBuildDataSource = query.addDataSource(tableNum(InventTable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(InventTable, rmsInsurancePercentage),true);
queryBuildRange.value(’>0’);
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}