i have a set list created where a lead singer chooses five songs that they are going to sing but i want to be able to display the keys for the songs the lead singer is going to be singing to help the musicians and vocal coach. i have a table with all the songs available and the leads singers respective keys but have been unable to get it to display.
So each lead singer can choose a list of five songs, and they also have a list of keys tied to those songs, not their “singer” profile? I see a bunch of key columns in the last screenshot and was not sure.
Yes, at the end of the song list i have the columns for each person to type in their keys per the song
I see what you’re trying to do, but I would suggest using this data structure instead:
Tables:
- Singers
- Songs
- Selections
You already have the first two tables set up. The third table would be a join table of sorts, where each singer would submit a form specifying who they are, what song they want to sing and the key in which they want to sing it.
Create a multiple relation between the singers table and the selection table in order to display the list of songs, they’ve selected in the key that they designated.
If needed, create a single relation between the selection table and the songs table so your users can view the song after viewing the selection.
Does this make sense or do you need to see a visual?
3 Likes
So create a separate table for the lead singers
Yeah. One table of unique lead singers per line, one table of unique songs per line, one table with singers selections (5 rows per singer).
1 Like