I want to make an app for our hunting team. The background is that we want some statistics, participation and animal killed. For each hunting event, there can be one or several animal killed, or non…
My design is that I have one table/sheet for all events (date, participated) and one table for hunted animal (shooter, species and so on).
What I dont seem to find is the relation between those tables? Because there is no static entity between them to relate to. Both are event that are made and you cant in advance know, I.e how do Glide know that this Shooting are related to a certain Event?
It´s the same problem if you thing of a sport event. You have a match in one table and the goal in a other table. How do you match them?
The goal is not to make up the event and then add the animal hunted, I want to do it at the same time (or at least that thats whats happing for the user).
Pls help! (I cant sleep )