Creating a calculation to search across related records
I have a student database that contains 3 related tables.
1-Students (student ID, name, etc)
2-Course Requests (each student has 8-9 course requests, and this table just contains the student ID and course ID)
3-Courses (all courses offered at the school including course ID, name, etc)
I am working on developing a letter to be sent home that lists the students course requests. Where I am getting stuck is that I want certain text to be included only if a student is requesting a particular class. So, if a student is requesting course A, the letter would say XXXXX, but if the student is not in that course, that text wouldn't be shown.
It seems simple enough, but I can't seem to get it to work for me? Any ideas?