I am creating a poker league leader board. We have several managers who run the game at different locations. We have stats for all kinds of things, but it in order for it to work, I have have to create my own table that includes multiple data sets connected to three different databases in order to keep the leaderboard up-to-date. Not done yet, but my trial run worked out pretty well.
Your games between 2 teams are like our games at a particular venue between 20-30 players at a time. There has to be player position table for that night which I associate with a venue data set with focus on rank, points, and bounties for that night.
Then the overall “standings” I associate with a player data set with focus on over all rank, total points and total number of bounties collected. The list will include their last three positions at a particular venue, who ranked above them and below.
To this I had create a Players, Venues, and League Database, each with multi-reference fields so that they could talk to each other.
Still need to figure out functions, but I think I might let an excel spreed sheet add those and then re-import that data from time to time.
All still in progress. I hope to have it finished soon, but again, it is all working pretty good in my tests so far.
In your case you will need a
Players Database (like our players)
Teams database
Games database (like our venues)
League database (like our league)
There are many already built out apps and services you could use and embed them into your site, but I really want to push Wix past some of the cruddy ones we’ve used in the past.
Teejay