I have somewhat of a beginner-type question.
Could someone look at the below relationships and let me know why I can't get the following form/query to only show the unique Appointment letters? I have 143 appointment letters. I have 135 members. I have 585 records in the junction table. I know that I messed up the form source query (below), but how badly am I off? Your expertise is greatly appreciated.
- 3 Example databases
- 4 MS Access 2003/2010/2013 books
- 5 links:
- Querying a many to many relationship in access
- Help with Access many-to-many relationship (beginner)
- Query Multiple tables in MS Access
Screenshot of Relationships:
SELECT DISTINCTROW tbl_apptltrs.*, jtbl_apptltrs_mbrs.*, tbl_mbrs.* FROM tbl_mbrs INNER JOIN ( tbl_apptltrs INNER JOIN jtbl_apptltrs_mbrs ON tbl_apptltrs.ApptLtrsID = jtbl_apptltrs_mbrs.LinkedApptLettersID) ON tbl_mbrs.MembersID = jtbl_apptltrs_mbrs.LinkedMembersID;