2 portals from the same related table on one layout
I am attempting develop a data base to track my sons hockey league.
I have determined that I have a many to many relationship between the tables teams and game and as a result I added a join table called participants
I have placed a portal on the game layout based on the relationship with participant and all works as expected, but I would like to display two portals one displaying values for the visiting team and one for the home team, both portals will need to display values from the team table. It is at this point I'm stuck.
I think the solution involves a table instance of one of the existing tables but my knowledge of this approach is limited. Any help would be appreciated and I thank you all for your consideration of my problem.