How to determine enrolment status

Discussion created by kongphui on Apr 27, 2015
Latest reply on Jul 3, 2016 by clayhendrix

I have a table storing students names, and another table storing enrolled_courses. 


In the enrolled_courses table, I have a variable that checks the end date to determine if the student has ended, or still currently enrolled.


Hence each student would have a few enrolled courses, and some already ended, some still currently enrolled.


Now I want to determine if a student is currently enrolled in at least 1 course, or totally not enrolled (means have quitted for good).


From the context of the student table, I would be able to see each student's enrolments.

How can I use this to form a calculation that: if there is at least 1 enrolled course for a student, then the student is enrolled, else the student is ended.


I guess my approach might be wrong, hence would like to find out if anyone has done something like this before.  Thanks!