Many to many match field question

[EricaMac]

I'm hoping that someone can help me with a student database I'm trying to enhance. All of the student information is already in the database, but I want to add information on a course that some of the students are taking in a way that it will let me track their attendance for each session.

I started a new table for the course information that includes course date, faculty (each week a different faculty member teaches), and academic year since we'll have to be able to look up what year a student took this course in the future.

What I'm having trouble with is how to relate the two tables so that I can record for each individual student which sessions they attended. For some reason coming up with a match field is completely stumping me, though I keep thinking I'm just on the verge of figuring it out. I did have them relating on the academic year of the course, but with that every time I changed the attendance field for one student, it changed for every student for that date.

I hope I'm explaining this clearly. Any help or suggestions are greatly appreciated!

[Ender]

The Course_Year or Section_Year table that you have should have it's own primary key. You can then use that to link to the Enrollment records. The Attendance table would relate to Enrollment via an Enrollment ID.

If you need more, we'll need the specifics about what your tables are, what their keys are, and maybe a screenshot of your table occurence graph.