A
ALM
Three tables: studentTB, examTB, juntionTB.
studentTB : studentId studentFirst, studentLast ,class, section.
examTB : examId, examName, class, section, term, type, points, ratio.
junctionTB : examId, studentId, grade.
the class, section, term, and type entries are lookup fields from their
corresponding tables. i am not mentioning them now. it is not necessary.
i created a form to populate the student table.
I wish to create a form to populate the exam table. not only that. also i
wish to make this same form be able to filter students relative to 'class'
and 'section'. The students relative to the current exam 'class' and
'section' should only appear in a kind of subform and i should be able to
give these students their grade. eventually the grade and the examId are to
be sent to the junction table.
So, with this form i am able to create the current exam and also enter the
student grades. These students are the those in the current exam 'class' and
'section'. Thanks.
studentTB : studentId studentFirst, studentLast ,class, section.
examTB : examId, examName, class, section, term, type, points, ratio.
junctionTB : examId, studentId, grade.
the class, section, term, and type entries are lookup fields from their
corresponding tables. i am not mentioning them now. it is not necessary.
i created a form to populate the student table.
I wish to create a form to populate the exam table. not only that. also i
wish to make this same form be able to filter students relative to 'class'
and 'section'. The students relative to the current exam 'class' and
'section' should only appear in a kind of subform and i should be able to
give these students their grade. eventually the grade and the examId are to
be sent to the junction table.
So, with this form i am able to create the current exam and also enter the
student grades. These students are the those in the current exam 'class' and
'section'. Thanks.