Setting up tables for grades
On Fri, 23 Apr 2010 09:51:01 -0700, Gntlhnds
wrote:
This is what I am trying to do. I have a form whose source is tblStudents
with a combo box that selects the student. I then have a subform whose
source is tblCourseGrades as a datasheet. I have two field, Course and
Grade. Course is a combo box with tblCourses as it's source to select the
Course. This is not working for me, though. Becasue tblCourseGrade does not
have a Course field, I have to have the combo box unbound, which does not
work. If anyone has any idea as to how I should properly setup this subform,
I would greatly appreciate it. Thanks.
Well... if you want to record the course grade for a student, you must - no
option, no choice - record SOMEWHERE what course the grade is for!!! Why
doesn't tblCourseGrade have a Course field? What is its structure?
The problem isn't your form. It's your table.
--
John W. Vinson [MVP]
|