A
Alternative Teacher
I am a novice to Access, and I am trying to get the classroom management
database template to do some of the things that I need it to do.
In the assignments subform, when you click on the bottom section, it
automatically adds that assignment to all of the students in the class by
running an append query.
I need it to do something similar in the student assignments subform. That
is, I need it to automatically add all of the assignments for the given class
to that student in the results table. My students work independantly on a
set curriculum, so it is more useful to enter data by student than by
assignment.
I have come pretty close, I think, by imitating the other codes, but I just
don't know the program well enough to know what I'm doing wrong. I can only
get an append query to add the assignments without any regard to what is
already in the results table, creating duplicate assignments for that
student.
I haven't really tried to get it to be automatic yet.
database template to do some of the things that I need it to do.
In the assignments subform, when you click on the bottom section, it
automatically adds that assignment to all of the students in the class by
running an append query.
I need it to do something similar in the student assignments subform. That
is, I need it to automatically add all of the assignments for the given class
to that student in the results table. My students work independantly on a
set curriculum, so it is more useful to enter data by student than by
assignment.
I have come pretty close, I think, by imitating the other codes, but I just
don't know the program well enough to know what I'm doing wrong. I can only
get an append query to add the assignments without any regard to what is
already in the results table, creating duplicate assignments for that
student.
I haven't really tried to get it to be automatic yet.