Hi,
In runtime look up I am getting duplicate values…
I want filter Duplicate values.
In form Runtime Lookup…Suppose in the look up , 1001,1001,1002,1002 getting
I want get only 1001 and 1002.
how can we do it…
Regards
Sunil
Hi,
In runtime look up I am getting duplicate values…
I want filter Duplicate values.
In form Runtime Lookup…Suppose in the look up , 1001,1001,1002,1002 getting
I want get only 1001 and 1002.
how can we do it…
Regards
Sunil
You can Overwrite the lookup method and use group by fieldname…
like
tableLookup = SysTableLookup::newParameters(tableNum(Table2),this);
qbds = q.addDataSource(tablenum(Table2));
qbds.addSortField(fieldnum(Table2,Field1));
qbds.orderMode(orderMode::GroupBy);
tableLookup.parmQuery(q);
tableLookup.addLookupfield(fieldNum(Table2,Field1));
tableLookup.parmUseLookupValue(true);
tableLookup.performFormLookup();
How you are getting the Lookup?
Hi,
Please go through the below link for more info.:
http://msdn.microsoft.com/en-us/library/ms933718.aspx
Regards,
/Ashlesh