I’ve only just discovered AppSheet, my questions might be of noob-quality.
I’m trying to build a virtual motorsport Championship league organiser. I think the relational db structure is ok, but I’m having trouble getting it together in appsheet. (References… many-to-many)
A Track has a couple of track variations and a couple of available track times.
A Venue contains a track, with a specific track variation and a specific track time.
A Championship has a couple of venues.
So the reference between Tracks, TrackVariations and TrackTimes is easy. I figured that one out.
But now I’m having trouble creating Venues. I can select the track alright, but I also need to specify the related trackvariation and related tracktime (not just any, the one specificly related to that track).
Venues can have many tracks. But Tracks can also have many venues…
I’m lost… I can’t figure out how to do it…
Any help at all would be greatly appreciated…