Set up a calculation field, cCompleteFlag in Student_Course that returns a 1 if the course is completed and null or 0 if it is not. Then Sum ( student_courses::cCompleteFlag ) will return the number of completed courses and Count ( Student_Courses::Student_ID ) will return the number of such courses. If the sum = the count and the count is not 0, then the student's course work is complete.
Thank you for your quick response. I am a bit confused on where the sum and count would be utilized... I have the calculation field set up in student_course- would i set up separate fields for sum and count? Thanks again.
The sum and count calculations have to be evaluated from the context of the student table--either a calculation field defined in that table with the correct "context" selected or in script steps executed while a layout based on the student table is current or in a conditional format expression on a student layout.
Which method (or combination of them) is used depends on how you need to work with this data.
Please note that a single calculation can reference both the sum and count functions so you will not need separate calculation fields for each to show which students have completed all required courses.