Hi all, I've got a fun little challenge on my hands designing a system to track our family's board game collection and gameplay. Here's my base structure:
Games - list of all the games in our collection
Play Log - tracks the date, time, location, players, and outcome of all the games we play
Score Sheets - this is the connecting table between the logs and the players since there can be many players in a log and a player can play many games
Players - list of players
let's use a sample record, tracked all the way through my base:
Myself, hubby, and son play a game of Monopoly. The play log tells me we played at our home on 10/16/2023 at 6:00pm and then lists the 3 of us as players linked to individual records in the Score Sheets table. In each Score Sheet record, our final scores are recorded and calculated to determine the winner which is fed back into the Log table as the outcome.
Now, multiply that same scenario by 10-15 more games played with a variety of other people.
Here's what I would like to see:
A list of each person I've played a game with and how many games I've played with each of them.
My brain is blocked on this one. I was able to achieve something similar in which I wanted to see a list of the games I have played with how many times I've played each one.
The generate list of games I've played along with how many times I've played each.
Does anyone have suggestions on how I could accomplish this? Thanks so much!!!