AnsweredAssumed Answered

Creating a calculation to search across related records

Question asked by JacquiAdler on May 24, 2012
Latest reply on May 24, 2012 by GuyStevens

Title

Creating a calculation to search across related records

Post

Hi all!

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?

 

Thanks!

Outcomes