Sorry for being such a newbie to Access, but I would really like to know if and how I can solve my problem:
I need to set up a list with names and then connect them in pairs, and be able to make a query on all fields that lists the names and their mate. It is for a project with schools.
My list of names could look like this in a table:
Steve, New York, US
Martin, Los Angeles, US
Adam, San Diego, US
I would then like to connect each person with one other person, and when I search for “New York” I will get all people in New York listed together with the people with whom they are connected. Like this:
Steve, New York, US - Carl, Miami, US
Paul, New York, US - Matt, Maine, US
etc.
Please let me know how to do. Thanks.