Updating records

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
>