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?