I am creating a database to track various aspects of my compositions. The main table would be Works (title, duration, difficulty, etc.). Then a table for Performances and one for Submissions. The relationship from Works to Performances is 1- many and the one for Works to Submissions is 1 - many.
I am thinking I would have a main layout for works and then some way to get to the related data. I used a portal for Performances, but I really wanted to include more fields. Then I couldn't figure out how to access the Submissions. It didn't look like I could have 2 portals.
Thanks in advance