More efficient way to reference multiple datasets?

Thanks so much for your help. I had it working in theory before but due to the formats of the Lineups I’m struggling to workout how to link it up.
To give a bit more detail, each venue has 1 lineup. A “lineup” is a list of 5-20 Names that each has a start time.

I tried to put all lineups on one collection and then reference the venue. But in my dynamic page I had to individually connect up the names/times e.g. Artist 1 Name, Artist 2 Time…Artist 19 Name… and so on. Because of this it wasn’t dynamically displaying the amount of acts in each venue and the venues with less acts had a load of “heading” sample text.

So instead I have seperated each lineup into it’s own collection so that the repeater pulls the exact amount of acts. See example below where “Broadway” is the name of venue.

The issue with this however is that I can’t figure out how to dynamically connect this to all the pages. I also can’t manually add a different venues lineup onto each page as they are dynamic pages so every change I make to 1 page is made to all of them.

How can I reference an “Act Name” and “Act Time” if these fields only exist within the specific collections of the lineup and not the overall venue dataset that the rest of the page is using?


Alternatively if there is a way to display content outside of my main venues collection on these dynamic pages and reference a unique lineup collection per page that would solve the issue too.

Hope that makes sense

Thanks
Alfie