select distinct
populate a dynamic dropdown with unique values from a single database field.
Overview
The issue arises when using the Read Data action in CF, which by default retrieves all records, including duplicates, for a field.
To get only distinct values, modify the SQL query in the Read Data action to use a GROUP BY clause on the specific field instead of SELECT DISTINCT.
