AnsweredAssumed Answered

Value List question

Question asked by bwbono on Apr 22, 2009
Latest reply on Apr 22, 2009 by davidanders

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 

Outcomes