AnsweredAssumed Answered

3 Related Tables

Question asked by jfrasier on Oct 18, 2017
Latest reply on Oct 19, 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.

 

Thanks in advance

Outcomes