Lookup field point to address field show multiple entry of the same value
Hello guys
I have a vendor form with the address field.
This form have multiple vendors on the same city, so the country, state, and city are the same for many of them, only the street change.
Let's say I have 10 vendors in Canada, and 5 in Australia
If I create a lookup field that point to that form and to the address field, I have a list of addresses.
If I remove all the fields and choose to show only the country, of course I will have a dropdown that show the word Canada 10 times.
How can I show the value in a unique way? so Canada and Australia only once?
Thanks for your help