Hello, I know this has been posted before, but I'm just not seeing enough details in the answers to get me through. Please help if you can!
I run a travel database, and each traveler is usually traveling with their spouse. 10% of the time they travel alone. I need to make mailing labels (among other merged documents) where I can send items to one spouse/traveling companion, or both if they happen to register for a trip together. I've followed the advice of other forums, and have two different tables: one for all travelers (TravelerID, HouseholdID, Last Name, First Name, Email). And the second table is a Household table (Household ID, Address, City, State, Zip).
I've tried making a query to bring both the first and last name of each couple, but then they appear twice (John and Jane Smith at 123 Bldv. then Jane and John smith at 123 Bldv).
What exactly am I doing wrong? How do I get rid of the duplicates? Is it somewhere in the relationship that I need to edit? I'm new to Access (only a month in), so the more specific the better. I just started learning about joins, but unfortunately I can't get much farther.
Thank you, lovely community!
Bridget