Hi,
I haven't worked with Access much, and for work I need to create a report that draws from the following tables:
-Scholarship (includes fields: scholarshipID, scholarshipName, description)
-Student (fields: studentID, name)
-Donor (fields: donorID, name, scholarshipID)
-StudentToScholarship (fields: ID, studentID, scholarshipID)
Since Student and Scholarship is a many-to-many relationship, I created the StudentToScholarship table to keep track of the relationships. But I can't figure out how to make that work with a report.
The report is supposed to list each scholarship and the students and donors affiliated with it. I know more or less how to set this up in MySQL, but how do I do it in Access?
Thanks so much!