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…
USA
Joe
Jane
THAILAND
Jane
GERMANY
John
ITALY
John
Joe
UK
Jane
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…
GERMANY, ITALY
John
USA, ITALY
Joe
USA, UK, THAILAND
Jane
How to make this work with another View, a linked Table, what?
Thanks in advance.
-Stephen