Hello to everyone
I have a basketball scouting database, I think it's pretty simple but it's been very helpful to me to keep up with my scouting reports and all kinds of information for my job.
I have a "teams" table in which I display a portal that shows records from my "player" table. So, every team record shows the players that currently play for the related team. But I also have another table called "Europe" that also features players but from a different continent. I was wondering if I could make the portal to show records from both "player" and "Europe" tables. When I go to edit layout mode and click portal setup I'm only allowed to show records from one table. It works for "player" but not for "Europe". I'd like to make it work for both. Is there a relationship path that I could make in order to make it work?
My relationship path is as shown below.