I have a table that houses 260 records. Each record represents 1 Song.
I have a rollup in that table that has every date I have practiced that song in my set lists.
Set lists are individual records that track each show and adds the song in the position played.
I want to take that list of songs and the date rollups and create a new table that has all the songs listed one by one by date played.
I know moving forward I can do this by automation as the records are created, but how do I do it for everything in the past?