I am trying to build an app for my sons gymnastics team to make it easier for the parents to track scores and progress across seasons. I have been looking at a few other sample apps, but am stuck on a couple of major things.
I have a separate table for each meet, which holds the meet scores. In each Meet Score table is a column for the athlete, each apparatus (with the value being the score) and then an All around score. I then have a finaltable listing all the meets, dates for the meets, location, etc.
What I want to do is have the first screen be a “Meet Selection” where you choose the Meet. Then, the next screen will show the athletes and their scores for that athlete at that meet.
Where I am stuck is on how to connect the data between two tables (An individual Meet Score table and the general Meet table). I have tried using reference, but just can’t get it working where when you click the Meet name I want it to take you to the score data for that meet. Instead it just gives the more details on that meet such a location.
Are there any tutorials you would recommend that would be very close to this use case?