Vision DropDown Component - How to Limit Query results that match

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?

Since you are only pulling from one column, use SELECT DISTINCT

2 Likes