many-to ••• relationship

[maybe]

Please help, I just can't seem to get this figured out..

The scenario is that the teacher gives the students of which there are 25, a
packet assignment for each week which consists of six subjects. Each subject
is worth 10 points as well as a test worth 40 points, for a total of 100
points possible for that week.

Tables are:

Subject(SubjectID, SubjectName)

Assignment(AssignmentID, AssignmentName, DueDate, PointsPossible)

Student(StudentID, StudentName)

StudentSubjectAssignment(AssignmentID, StudentID, SubjectID, SubmissionDate,
PointsEarned)

It seems just about impossible for me to make a form showing the assignment,
subject, and student with corresponding score.

Thank you

 

[rpw]

Here is a query SQL that accomplishes showing the assignment, subject and
student with submission date and points earned. You can start a new blank
query in design view, switch to SQL view and paste this into it.

SELECT Student.StudentName, Assignment.AssignmentName, Subject.SubjectName,
Assignment.DueDate, StudentSubjectAssignment.SubmissionDate,
StudentSubjectAssignment.PointsEarned
FROM Subject INNER JOIN (Student INNER JOIN (Assignment INNER JOIN
StudentSubjectAssignment ON Assignment.AssignmentID =
StudentSubjectAssignment.AssignmentID) ON Student.StudentID =
StudentSubjectAssignment.StudentID) ON Subject.SubjectID =
StudentSubjectAssignment.SubjectID;

You might want to use it as the Record Source for your form. Good luck.