I am trying to Use a Vision Dropdown box with a SQL Query binding to fill in it's possible selections.
I am getting valid results, only when multiple rows contain the same value the dropdown box displays a selection item for each row.
Here is my SQL Query Binding for the Drop Down.
And also for reference, here are the Drop Down properties.
How do i setup this dropdown so even if there are hundreds (which there will be) of Batch numbers that match only one will be displayed for each unique value?