Query based on multiple tables (1 Viewer)

[Kyp]

@mike60smart
@The_Doc_Man
@Pat Hartman
@cheekybuddha

Thank you all for the help.

I still don't understand what I do not know therefore, I just don't get it...lol

I realize my relationships were not correct, was that the only issue, or was it the fact that a query could not do what i was trying to do?

 

[mike60smart]

@mike60smart
@The_Doc_Man
@Pat Hartman
@cheekybuddha

Thank you all for the help.

I still don't understand what I do not know therefore, I just don't get it...lol

I realize my relationships were not correct, was that the only issue, or was it the fact that a query could not do what i was trying to do?

Hi
You covered it with your statement "A Vendor can have Multiple Locations and Each Location can have Multiple Contacts"

If you map this out on a piece of paper then you need at the least 3 Tables.
Vendors
Locations
Contacts

If you look at the Relationship Diagram the Vendor PK is linked to the Location FK and
the Location PK is linked to the Contacs FK.

Your Data input would then be carried out by means of a Main Form for Vendors and a Subform
to cater for the relationship between Locations & Contacts.

You would not be able to achieve this by just using a Query.