How do you ahve them sorted?
You can have them organized by class, associating students
and teachers with
a specific hour of class. No student or teacher should have
two classes
durign the same hour (from what i remember).
teacher table -
teacherID
student table-
studentID
Class table
cID TeacherID StudentID Hour
pk Teacher's ID Student's ID Hour
Then for a class listing you just have to pull the teacher's
ID from your
session variable and do an INNER JOIN to join the student
data with their
class WHERE tableClass.studentID = tableStudent.StudentID.
GROUP BY
tableClass.Hour ASC
Next, just do a do while statement, breaking your different
hours into
sub-sections (i'll let you figure that part out, that's where
it gets fun)
Hour 1
Student Name Other Info
Student Name Other Info
"denman" <webforumsuser@macromedia.com> wrote in
message
news:e9nm5a$mjt$1@forums.macromedia.com...
>I am developing an app that will allow teachers to enter
academic data and
> reports for their students. I would like them to be able
to call up the
> whole
> class at once so they can write the report for one
student and go straight
> onto
> the next. What would be the best way to do this? ideally
either the whole
> class
> would appear one after the other, or the user would
navigate from one to
> the
> next. I have the dataset sorted but I would like some
advice on how to lay
> the
> records out for updating.
>
> Thanks in advance
>
3
Replies
AdChoices