AnsweredAssumed Answered

Join Relationship Question

Question asked by sccardais on Oct 9, 2014
Latest reply on Oct 9, 2014 by sccardais


Join Relationship Question


I have two tables (Users and Cohorts) connected via a Join table as shown on the attached screenshot.

Users has a unique User_ID field and many other attributes of Users.

Cohorts has a unique Cohort_ID and CohortName.

When Users are chosen for a specific mailing list, I want to create a join record containing their UserID and the Cohort_ID.

I would also like to be able to view all of the Users in a specific Cohort by finding a specific Cohort_ID.I thought I could do this by creating a layout based on the Join and adding a portal to view related Users.

Then, by finding a specific Cohort_ID in the Join table, the portal would display only the Users assigned that specific Cohort_ID in the portal.

That is not happening and I'm not sure why. Can anyone explain this to me?