We are building an event app for live music. Each event (gig) has potentially multiple acts associated with it. On the Event Details Page I want to display the Headline Act and the Support Acts separately, as such, I have set up two relationships in the Events database to the Acts database: one I have named Headliner (only one headliner per event), and the other is named Support Acts (multiple support acts per event).
I have set up the Headliner Act as a “Many gigs, one Act” and it displays on the Event Details page as expected.
I have set up the Support Acts as “One Gig, Many Acts” (because there can be multiple Support Acts at one gig), yet when I am trying to build a list to display it won’t let me select the Support Act Name and if I try to add the multiple support acts to the event listing, it directs me to add it via the Acts Collection, rather than the gig. (See attached image)
What am I doing wrong?!?!