Display records in portal in which one field does not match a field in another table?
Been struggling with an issue in a database I am creating for awhile now, and searching these forums has not provided me with the answer.
I have a database in which one table, "Curriculum", holds records that contain fields for Modules and Sub Modules, among other fields. Another table, "Evaluations", allows a user to select a contact and complete an evaluation for a given Module or Sub Module from curriculum, which is stored as a new record in the Evaluations table.
I have a third table, "Contacts", which holds all of the names and basic information for each student. Under their contact details, I want to display a list of all Sub Modules from the Curriculum table that have not been completed in a record for that contact in the Evaluations table.
Any help you could provide me in designing a script or a portal filter to display these results would be much appreciated.