3 Related Tables

Discussion created by jfrasier on Oct 19, 2017
Latest reply on Oct 20, 2017 by jfrasier

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