troubleshooting Question

displaying many to many linked tables

Avatar of jcolles
jcolles asked on
Microsoft AccessMicrosoft Excel
8 Comments1 Solution404 ViewsLast Modified:
I am writing a database for a charity that has contacts some of whom attend events and where they may pledge or make donations to the charity. The attached relationship diagram shouws my basic design.  
I am trying to display a contact form with a subform showing an events datasheet so that an event can be  selected. I have used a query  (SQL code below), but it always remains empty as all conditions are not satisfied until the data has been entered.
I am going round in circles, please can someone help!!
SELECT Contacts.CustomerID, ContactEvent.ConteventCustID, ContactEvent.EventID, ContactEvent.Invited, ContactEvent.Accepted, ContactEvent.Attended, ContactEvent.[Amount Pledged], ContactEvent.donationID AS ContactEvent_donationID, Events.EventID, Events.EventName, Events.Location, Events.Date, Events.Cost, Events.Comments
FROM Contacts INNER JOIN (ContactEvent INNER JOIN Events ON ContactEvent.ConteventCustID = Events.EventID) ON Contacts.CustomerID = ContactEvent.ConteventCustID;
relationships.jpg
ASKER CERTIFIED SOLUTION
harfang

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros