J
Jareddxp
### How can I use relationships to auto-create records in my subform? ###
Please Help!
Using Access 2007, I am trying to create a "Classroom Database" where I can
manage students and grades (for one class). I have created the following
tbl.Student
-SID (auto)
-LastName
-FirstName-
-StudentID
-Comments
tbl.Assignments
-AID (auto)
-Date
-Assignment
-Notes
tbl.Grades
-RID
-Student (looks up student ID)
-Assignment (looks up assignment)
-Grade (%)
-Note
Thus far, I have created two forms (each with a subform), one which allows me
to open up an assignment and see grades by student, and another where I can
view all of a students grade.
### My question, and I have seen this before, is that I would like ALL of the
students to be added to each assignment automatically. As it is now, I need
to add a new record for each student under each assignment (grab their name
from the dropdown list). How can I setup the subforms to automatically
propogate a GRADE record with each student name and a blank Grade field? ###
Thank You! Jared
Please Help!
Using Access 2007, I am trying to create a "Classroom Database" where I can
manage students and grades (for one class). I have created the following
tbl.Student
-SID (auto)
-LastName
-FirstName-
-StudentID
-Comments
tbl.Assignments
-AID (auto)
-Date
-Assignment
-Notes
tbl.Grades
-RID
-Student (looks up student ID)
-Assignment (looks up assignment)
-Grade (%)
-Note
Thus far, I have created two forms (each with a subform), one which allows me
to open up an assignment and see grades by student, and another where I can
view all of a students grade.
### My question, and I have seen this before, is that I would like ALL of the
students to be added to each assignment automatically. As it is now, I need
to add a new record for each student under each assignment (grab their name
from the dropdown list). How can I setup the subforms to automatically
propogate a GRADE record with each student name and a blank Grade field? ###
Thank You! Jared