www.webdeveloper.com
Results 1 to 4 of 4

Thread: Select redirect??

  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    220

    Select redirect??

    Hi there,

    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.

    *****
    Example

    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!!

    Thanks/...

  2. #2
    Join Date
    Jun 2006
    Posts
    472
    what database are you using and what language are you using to get the information?

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Quote Originally Posted by aussie girl
    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.

    Language is English!! - Classic ASP

  4. #4
    Join Date
    Nov 2006
    Posts
    16
    If there isn't too much data, you could just get it all in one lump, save it in arrays in JavaScript, and render as needed.
    If the amount of data is considerable, you'd be better off with some AJAX-ey JavaScript, that'd send small requests for exact data to be rendered at selection time.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles