I am displaying data in a dropdown where the data in the field has duplicate entries. Iwould like to only display each duplicate entry once.
My dropdown is set to display values from a_dept so it displays ‘Dept 1’ twice because there are 2 records with Dept 1.
How do I limit the dropdown list to display ‘Dept 1’ only once.
Sorry if this is a silly question…I’m new here.