hi
I have dialog in this dialog I make combobox user can choose record in this combobox but if they have 3000 record or more user make time to seach the record manually than I would like make search in dialog for this combobox ?
how I can do this ?
thank you
try overriding the lookup method for the combo box
public void lookup()
{
SysTableLookup sysTableLookup;
Query query;
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
;
query = new Query();
queryBuildDataSource = query.addDataSource(tableNum(YourTable));
// set the range etc
sysTableLookup = SysTableLookup::newParameters(tableNum(SalesTable), this);
sysTableLookup.addLookupfield(fieldNum(YourTable, Field1));
sysTableLookup.addLookupfield(fieldNum(YourTable, Field2));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
-abid
hi
I knonw that but this is a lookup in this lookup how I can make search ?
thank you
this the override code for lookup method and it allows me to do the “find” function
#public void lookup()
#{
SysTableLookup sysTableLookup;
Query query;
QueryBuildDataSource queryBuildDataSource;
QueryBuildDataSource queryBuildDataSourceSalesLine;
QueryBuildRange OpenSalesRange;
;
query = new Query();
queryBuildDataSource = query.addDataSource(tableNum(SalesTable));
sysTableLookup = SysTableLookup::newParameters(tableNum(SalesTable), this);
#// AMahmood 20 April 2011 - HT_225_ProjPMStatusInquiryProductLin - BEGIN
if(dimProductLine)
{
queryBuildDataSourceSalesLine = queryBuildDataSource.addDataSource(tablenum(SalesLine));
queryBuildDataSourceSalesLine.joinMode(joinmode::ExistsJoin);
queryBuildDataSourceSalesLine.relations(true);
queryBuildDataSourceSalesLine.addRange(fieldid2ext(fieldnum(SalesLine, Dimension),2)).value(dimProductLine.text());
}
#// AMahmood 20 April 2011 - HT_225_ProjPMStatusInquiryProductLin - END
#// AMahmood 25 April 2011 - HT_225_ProjPMStatusInquiryProductLin - BEGIN
OpenSalesRange = queryBuildDataSource.addRange(fieldnum(SalesTable, SalesStatus));
OpenSalesRange.value(queryValue(SalesStatus::Backorder));
#// AMahmood 25 April 2011 - HT_225_ProjPMStatusInquiryProductLin - END
sysTableLookup.addLookupfield(fieldNum(SalesTable, SalesId));
sysTableLookup.addLookupfield(fieldNum(SalesTable, ProjId));
sysTableLookup.addLookupfield(fieldNum(SalesTable, SalesName));
sysTableLookup.addLookupfield(fieldNum(SalesTable, CustAccount));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();