Update multiple tables

G

glock26girl

I'm sure this gets asked a lot, but I haven't found any answer that helps me.
Basically I have a Student/Class/Test db. I have one table that inputs
which students are taking which classes. I have another table that has all
of the tests in it, and which class they are for. I know I can make another
table that I would have to select each student for each test, but I'm afraid
it will be too complicated, and tedious, when I turn the db over to the
school. Is there any way that I can make it say, if "this student" is taking
"this class", then "these" are all the tests that the student will take, and
be able to store the grades for all of those tests?
 
J

James Hahn

Since you know what classes each student takes, and you know what tests are
applicable to those classes, you can easily create the third table from a
query, so I don't understand why you regard this third table as too complex.
There is no way you can avoid entering each student's grade for each test,
however.
 
G

glock26girl

If I make a make-table query, though how can I store their grades, AND be
able to update it every time I put a new student into another class?
 
J

John Vinson

If I make a make-table query, though how can I store their grades, AND be
able to update it every time I put a new student into another class?
Click to expand...

Use a Form based on the Students table, with a Subform based on the
"enrollment" table (student-class table).

If you're entering data into Table datasheets... well, don't. Table
datasheets are for debugging and design only. Data entry and editing
should be done using Forms, usually with Subforms for one to many
relationships.

John W. Vinson[MVP]
 
Top