Searching for records that aren't related

[muskee]

Hi guys, Please help!

So I have 3 tables,
Student --< Enrollment >---- Course

 

I would like to search for the students that haven't enrolled on a certain course.

For example I have this course:
Id        Name                                      Credtis
202     Artificial Intelligence                4

In the enrollments table I can see everyone that has taken this course,

How can I search for the people that haven't taken this course?

[webko]

You could Go To Related records from Course to Enrolment to get who has taken it, and then Find Omitted.... to show the one's who haven't...

[muskee]

Yeah that seems to work, thanks!