Filter the dialog lookup values


In a table voucher_no is allow the duplicate values

I am using that field in report for dialog field, here in dialog look up it should not show the duplicate values

how can I restrict the duplicate values in Dialog lookup

sunil kumar

you can code before sysTableLookup.parmQuery(query);


queryBuildDataSource.addSortField(fieldnum(Table, Field1));

queryBuildDataSource.addSortField(fieldnum(Table, Field2));