How do I run a query to show my customers and ALL of their services?

[NotaryEtc]

Hello all,



I have the following tables:

CustomerT
MVT
NotaryT
GDT

My CustomerT has a many to many relationship with my MVT and also with my NotaryT using junction tables.

I have a one to many relationship with my CustomerT and my GDT (one customer can have many gd records)

How do I run a query that shows ALL of the services that any one customer has received? The only details I need are the customer name, service received, date received.

This seems like it should be easy but I can't seem to figure it out.

[June7]

This seems like a simple joining of tables. What exactly is the issue you encounter? Have you used the query builder?

[NotaryEtc]

I clicked on query design, added the tables, and brought in the fields.....but it doesn't return any records.

[June7]

What are the join types? INNER joins will require related records in all tables. Possibly should be RIGHT or LEFT joins. Post the sql statement for analysis. Which are junction tables?