Hi folks
New to Caspio, but not to relational databases!
I've been setting up a website for my band, and I'm trying to get a gigs archive from which you can drill down to setlist data. I've set up tables Gig, Song and a m2m table between them called GigSong. I've made a view with the song and gigsong data so I don't have to catalogue the name of the song every time I update that table, just an ID.
So, the main Gig dataPage is fine, and it drills into a page which has 2 dataPages- one for gigDetails, so you know you're on the right one, and one for setlist. The gigDetails takes the