Many to Many Relationship - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Many to Many Relationship

Michelle Fournet

3 years ago

I have a Students table, a Courses table, then a junction table called StudentsCourses. The Courses table has basic information about each course (not including specific course date offerings). Do I put the particulars about the course they are taking in the junction table? For instance the fields Term, StartDate, EndDate, Price, Grade, etc...

	Michelle Fournet OP @Reply 3 years ago

	Adam Schwanz @Reply 3 years ago
I probably would do that, the other option would be to make more courses, Math 2018, Math 2019 or whatever, but it seems easier to just do Math and then put the specifics in the junction. Definately do it for things that are going to be unique to the student in that course like Grade.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View