I am in the process of building a database that contains tables for Personal Info (Name, DOB, License #), Addresses (Street, City, County, State), and Phone Numbers. I have done this because one person often has multiple addresses and/or phone numbers
I have successfully linked the tables with a primary and foreign keys and created a form with subforms to enter data into every table at once.
The one problem I am running into is with my queries. Ideally, I would like to try and have it that when I search someone's full name it gives me all of their information without repeating.
For example, John Smith has lived at 123 Main St and 54 1st St. He also has had the phone numbers 123-456-7890 and 555-555-555 attached to him.
When I run my query now, the output looks like this:
123 Main St 123-456-7890
123 Main St 555-555-5555
54 1st St 123-456-7890
54 1st St 555-555-5555
Is there anyway I can mitigate these duplicates? Thank you.
I have successfully linked the tables with a primary and foreign keys and created a form with subforms to enter data into every table at once.
The one problem I am running into is with my queries. Ideally, I would like to try and have it that when I search someone's full name it gives me all of their information without repeating.
For example, John Smith has lived at 123 Main St and 54 1st St. He also has had the phone numbers 123-456-7890 and 555-555-555 attached to him.
When I run my query now, the output looks like this:
123 Main St 123-456-7890
123 Main St 555-555-5555
54 1st St 123-456-7890
54 1st St 555-555-5555
Is there anyway I can mitigate these duplicates? Thank you.