Two Portals in One Layout
Relatively new to this but am slowly catching on. I've created a database to record a group of people and their involvement in a series of projects. I have a table of People, a table of Projects, and a join table of Interactions, which records the two foreign keys and information about each individual person-project interaction. This all seems to work fine, including the relationship between the three.
The trick comes in when I attempt to divide the interactions into two categories. A person can be involved in a project in one of two ways (Staff or Volunteer) and can change type from project to project. On the Project layout, I'd like to have two portals, one that lists all of the Staff for that project and one which lists all of the Volunteers. If I create a field in Interactions, I know how to sort by type, but I can't figure out how to actually have two, filtered portals.
Any help would be MUCH appreciated!