2 Replies Latest reply on Apr 22, 2009 7:54 AM by davidanders

    Value List question

    bwbono

      Title

      Value List question

      Post

      Hi all

      I am trying to build a database solution for a small private acting school.

       

      I have a STUDENTS table and an EXAMS table.

       

      In the EXAMS table, I would like to choose a number of students that are in the particular EXAM. I have a checkbox populated from a value list containing all of the STUDENTS.

       

      The question comes once I have gotten this far, I cannot figure out how I would take this group of EXAM STUDENTS and again separate them so I can then grade them individually (by MANY judges)...and then finally report this back to the STUDENT database.

       

      I would like somehow for each STUDENT to then have a separate record of these grades, but linked to the "master" exam.

       

      I hope this makes sense.

       

      I have to say I am aware that my programming design is nowhere near where it should be, but I am persistent! Hahahaha 

      Any ideas would be greatly appreciated. 

       

      Thanks