AnsweredAssumed Answered

Display records in portal in which one field does not match a field in another table?

Question asked by JayD_1 on Sep 29, 2014
Latest reply on Sep 30, 2014 by philmodjunk

Title

Display records in portal in which one field does not match a field in another table?

Post

Hi all,

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.


Thanks,
Jay

Outcomes