I am building a Db where people will be listed and one field will show where in the world they work. I’d like to be able to enter a record for John and say he works in Germany and Italy. Then, Joe is marked as USA and Italy. Jane is entered and marked as Thailand, USA and UK.
Is there a view where it lists all the options in the 'where do you work field" and if that person has a marking for that country, s/he shows up? For example, I’d like to see…
This would allow users to scroll to the desired country and see a list of people who work there - regardless of them being on any other multiple country groupings as well.
HOWEVER, what I get is…
USA, UK, THAILAND
How to make this work with another View, a linked Table, what?
Thanks in advance.