Drop-down lists display duplicate values unless Only Display Distinct Values is selected. When this option is selected, OnBase generates the distinct list of values each time the drop-down list is selected, which can incur a high cost on the database. It is considered a best practice to only select Only Display Distinct Values for small lists.