Show unique records

[business]

Hi,

How can I use lookup table settings to show only unique records of the table linked field?

https://cl.ly/69e27699b4c9

Thanks

 

[business]

Here is an example: https://cl.ly/d788681eb8d5

 

[eugenio]

Hi,
I would create a VIEW that reflects the linked table where you add a DISTINCT clause, however if you have duplicate values in the linked table my feeling is that there is something wrong in the design.

Best,