Report drawing from multiple tables

[Palladian]

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!

[June7]

Assume Scholarships and Donors also many-to-many relationship.

I think you will need to use subreport design.

[ssanfu]

One donor can have many Scholarships One to many

If One donor can have many Scholarships AND one Scholarship can have many donors, then you should also have a junction table for donors - Scholarships.

I changed your structure to:
-Donor (fields: donorID, name)
-Scholarship (includes fields: scholarshipID, donorID, scholarshipName, description)

Attachment 9403



See attached mdb...
My $0.02

[Palladian]

Thanks.