AnsweredAssumed Answered

Multiple Portal Tables on One Layout

Question asked by jamief on Nov 15, 2018
Latest reply on Nov 15, 2018 by Jason Wood

Hi there,


I am fairly new to database design so I apologize in advance for my ignorance. I am creating a database for my band. On one of the tabs of the layout, I want to be able to have the ability to enter 3 or 4 sets of songs in portal tables. I was thinking I'd have a portal table for each set where I can add songs from a drop down list. So far I have a Song table to store song data, a Set table and a join table called SongForSet which allows for multiple songs in one set. I am thinking I probably have it set up wrong, but need some guidance/advice on how to best implement this.


Thank you.