Comparing table data

[AnthonyDixon]

I have three tables: Student Info, Required Courses and Courses taken. I have a relationship from student info to required courses and courses taken.

From My Student Info screen I have created portals to my other tables. I would like to flag in my required courses portal which courses have not been taken for that particular student based on what has already been taken in the Courses taken portal.

I have a relationship between the Courses Taken table and the Courses Required table so I preform a lookup to populate a Course_ID field in the Courses Taken table.

A little lost on this one. Any help, ideas or suggestions would be greatly appreciated.

Thank You

Anthony

[comment]

Assuming the following relationships:

• Students::StudentID = RequiredCourses::StudentID

• Students::StudentID = CoursesTaken::StudentID

you can see if a required course has been taken by calculating =

not IsEmpty ( FilterValues ( CourseID ; List ( CoursesTaken::CourseID ) ) )

Alternatively, if you already have a relationship between the two tables based on matching both StudentID and CourseID, you can check for the existence of a related record by =

not IsEmpty ( CoursesTaken 2::CourseID )

where CoursesTaken 2 is the TO being used in this relationship.

[AnthonyDixon]

Both solutions worked flawlessly!

Thank You! Thank You!! Thank You!