If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autopopulate Form based on subform
### 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 |
#2
|
|||
|
|||
Autopopulate Form based on subform
Answered in another newsgroup where you posted this question.
|
Thread Tools | |
Display Modes | |
|
|