Dumb question...

[Kyp]

I have not been in MS Access for a while. When I was using access, I was just learning so I am back to square one.
I have two tables, tblVendorCompany and tblVendorContact. I've created a "One to Many" relationship as pictured below.

What type of query do I need to create to combine the two related tables correctly?
Sorry for the dumb question but I am back to square one learning access.

Thanks,
-Kyp

 

[Gasman]

I would start with the QBE window.
Bring in Company first then Contact and select relevant fields.
I would also have ID primary keys in both tables and use the PK of the Company table as the FK in the Contacts table.
Then when Acme Motor Company become Dave & Don Motor company, you just change a name once in the company table.

 

[Kyp]

Thanks @Gasman,

I will give it a shot.

-Kyp

 

[The_Doc_Man]

To amplify Gasman's advice, when you are done with the QBE window, you can switch your query view to SQL to SEE what gets built. The ONLY thing to remember about doing that is that somehow, that operation likes parentheses that in many cases are NOT required. It LISPS. (Lots of Insipid, Silly Parentheses Shown.)