Distinct Value List Items

Classic Servoy
1

How do I get Servoy to show only distinct/unique value list items from another table as FM does by default? THANKS IN ADVANCE!

ellen

2

it does this by default
Only then the display and return values must be the same. If not then we can’t do a distinct because you can have this:

ellen | 1
johan | 2
ellen | 3

if the name is display and the number is return
What should be returned when ellen is choosen? 1 or3??