@ryeradio1
You will not be able to accomplish what you want with the formula you are using for the Items property of the dropdown. The use of Distinct() produces a single column of unique values, for the column named in the function and renames that column Result. Thus, your formula appends a single column of codes on a single column of names, an illogical construct.
Instead you need to preserve the table structure that you have and use it as the items property of the dropdown. Instead of a dropdown, I suggest that you use a combobox control. An example is shown below
The combobox is sorted on the product code but the product name is used in the search. The layout chosen is the double one so that your users can see both the name and the product code.
An alternative would be to use AddColumns{} to add a concatenation of the name and code to your collection. The screenshot below shows how that would look. Users could search for a name or code in such a combobox.
