No duplicates in lookup field
I have a lookup field that is based on items from a material report.
The problem is, there are a lot of duplicate material names for the particular field that it's based on.
Is there any way to limit it to only show one of each item?