How can I stop SmartFill from creating duplicate results in the ‘Make a Selection’ window?
If SmartFill finds multiple records it will bring back all records that apply, even if they are duplicates. You can add a Filter at either the SmartFill Object or SmartFill Repository level to reduce or eliminate the duplicate records. If you apply a Filter at the Object level, the filtering will apply to all of your lookups for that Object (i.e., Items Object filter applies to all item lookups). If you apply a Filter on a lookup at the Repository level, the filtering will apply only to that one lookup.
A scenario where a Filter is necessary to avoid duplicate results is when you have added a secondary table to your lookup, such as IV_Item_MSTR_QTYS on the Items Object. SmartFill returns duplicate results in this situation because it is pulling item records from both the IV_Item_MSTR table, and the IV_Item_MSTR_QTYS table. So, to avoid this you would open your Items Object and click on the Filter button. In the Filter window you would choose the ‘IV_Item_MSTR_QTYS’ table in the Table Name column, the ‘Record Type’ in the Table Field column, the ‘Equals’ in the Operation column and the type the number ‘1’ in the Value field.