I am trying to create a db to track grades for three classes. I created 4 tables:
Classes - Fields: ClassID (grades -10, 11, 12), ClassDescription
Students - Fields: StudentID (autonumber), ClassID, FName, LName
Assignments - Fields: AssignmentID (autonumber), AssignmentName, Points, Date...etc..
Grades - Fields: GradesID (autonumber), PointsEarned, LetterGrade, StudentID, AssignmentID
Tbl Relationships:
Classes - Students (ClassID)
Students - Grades (StudentID)
Assignments - Classes (ClassID)
Assignments - Grades (AssignmentID)
I have an Assignement form that is linked to the Assignments tbl and allows the user to enter the ClassID and name of the assignment and the other fields. I am trying to create another form that is linked to the Assignments form. On this form I want the names of the students from the ClassID selected on the Assignments form to appear. I then want to enter the students grade that will link to the GradesID.
Are my tables set up properly? I'm new to this so I'm not quite if I'm using the right approach.
Any advice would be greatly appreciated!!!
Classes - Fields: ClassID (grades -10, 11, 12), ClassDescription
Students - Fields: StudentID (autonumber), ClassID, FName, LName
Assignments - Fields: AssignmentID (autonumber), AssignmentName, Points, Date...etc..
Grades - Fields: GradesID (autonumber), PointsEarned, LetterGrade, StudentID, AssignmentID
Tbl Relationships:
Classes - Students (ClassID)
Students - Grades (StudentID)
Assignments - Classes (ClassID)
Assignments - Grades (AssignmentID)
I have an Assignement form that is linked to the Assignments tbl and allows the user to enter the ClassID and name of the assignment and the other fields. I am trying to create another form that is linked to the Assignments form. On this form I want the names of the students from the ClassID selected on the Assignments form to appear. I then want to enter the students grade that will link to the GradesID.
Are my tables set up properly? I'm new to this so I'm not quite if I'm using the right approach.
Any advice would be greatly appreciated!!!