Calculation field problem
There are 2 tables:
Class Table & Registration Table
Fields in Class Table:
"Class ID" & "Class details" & "No. of Registration to this class" which is a calculation field I am having trouble with.
Fields in Registration Table
"Class ID" & "Status" . For Status the data may be "In Progress" & others"
So in the "No. of Registration to this class" field, I want to set up a calculation to look for the number of registration to this class with Registration Status "In Progress". The result maybe like" 10 students has registered for this class." Since a class will have a upper limit of students.