How would I achieve the following?..
I have 2 selection lists, one for Class and one for Student. I also have 2 static fields - one called Tutor Group and one called Subject.
The class list is auto-generated from a database, based on the logged on user (this is a local intranet). Once they have selected the class, I need the Subject field to be automatically changed to match the class (also database).
The student name list should be disabled/hidden until they have selected the class they are teaching, at which point I need the Student Name list to become available, and list all students in the selected class (also database).
Then, once they have selected the student, I need the Tutor group field to be automatically changed to reflect what's in the database.
Page loads. The teacher name is auto generated from the logon account. Their class lists are picked up from the database, but no students are listed.
**Let's use a real class here, Ip/11b, which is an IT class.**
They select Ip/11b, which means nothing to a supply or cover teacher, so the Subject field get's updated with the correct info, and all students from that class are now listed in the Student Name selection list.
They select a student from the list, and the Tutor Group field get's updated with the correct info.
End of example
I'm fine with the database design/connections. I just need help getting the right info to appear at the right time!!
what database are you using and what language are you using to get the information?
It's an access database at the moment, but will move over to SQL 2005 once it's complete.
Originally Posted by aussie girl
Language is English!! - Classic ASP
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)