Hi,
I am trying to create a lookup based on 2 fields, not sure if this would work. Please let me know any other way possible. Thanks.
public void lookup() { Query query = new Query(); QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(custTable), this); sysTableLookup.addLookupField(fieldNum(CustTable, AccountNum)); sysTableLookup.addLookupField(fieldNum(CustTable, CustGroup)); queryBuildDataSource = query.addDataSource(tableNum(CustTable)); queryBuildRange = queryBuildDataSource.addRange(fieldNum(CustTable, CustGroup)); queryBuildRange.value('40'); queryBuildRange = queryBuildDataSource.addRange(fieldNum(CustTable, Field2)); queryBuildRange.value('SomeValue'); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); //super(); }
Could you explain your problem, please?
I need to create a custom lookup,
Based on ‘Field1’ and ‘Field2’ selection in a form, system should filter out applicable Field3 and display in drop-down for selection.
So what's the problem? You seem to know how how to create lookups and how to filter them - maybe you don't know how to get values for your ranges or something. Please explain.