Actually, I was able to take what you had there, modify it a little to match
what I needed, and it worked. Thanks.
"Damian S" wrote:
> Hi Alternative Teacher,
>
> If you post your code here, we'll see if we can spot what you are doing
> wrong... You probably just need to limit the ones that get added to those
> that don't already have a match, similar to this:
>
> insert into tblStudentAssignment(StudentID, AssignmentID) select
> me.lngStudentID as StudentID, AssignmentID from tblAssignment where
> AssignmentID not in (select AssignmentID from tblStudentAssignment where
> StudentID = me.lngStudentID)
>
> Hope that makes sense...
>
> Damian.
>
> "Alternative Teacher" wrote:
>
> > 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.
> >
|
Similar Threads
