I have a problem and I hope someone could help me with this.
I have a student registration database.
The case is that there is courses that student can register in.
And when they register there a groups formed for the courses. So there may be 2 groups that give the same course depending on how much students register.
The courses are divided in two levels, so there are courses that is level1, and level2.
The level 1 courses are teached in one day. So they are one day course.
The level 2 courses are teached in 5 days. so they are a 5 days course.
The students can only make the exam if they attend to the courses.
For the 1 day course they have to attend 1 time.
For the 5 days course they have to attend at least 3 times.
So I have made a query which I get the list of the students that can make the exams. That was easy.
But now I have to add a mark field for only the students that was allowed to attend to make the exams.
My problem is now that I don't know how to incorporate this table. So I can register the marks for the students that only was allowed to take the exams.
The exams are a one time exam, so that determine if you pass the course.
Please help me.