Having trouble with my basketball stat tracking solution
I'm building a solution trying to track certain stats for my basketball players per game.
I'm tracking each possession of the game and connecting if a player screens well or not. We have 82 games
The stat I am trying to track is screening. Every possession I want to link to a player and track if he screened or not, did we score on that play, etc.
I'd like to have a report on the game listing all the players on my team and how many screens they attempted and connected on.
In the players table I'd like a portal listing games and their stats.
I have a players table, game table, and a possession table. I was setting up the solution like this
Not sure if this ail work the way that I need ti to.
I have a player's table