Jump to content

Need some direction in structuring a database


This topic is 4398 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am trying to set up a database for my 8-ball league. Currently, I am doing it in Numbers and that works ok but I am thinking that FMP could automate things a little better for me.

We have 16 teams of 5 or more players and we have a 25 week schedule. What I would like do is enter the data for each match of each week and then have FMP calculate all of the appropriate team and individual stats. Each match has 5 players from one team playing against 5 players from another team. We play 7 rounds of 5 games. Spares can go in and replace players as the match progresses. Players can play for other teams when necessary.

We use a handicap system where the score for a single game can be from 0 to 17.

I already have a layout done for entering an individual match and calculating a summary for all players and spares used in that match. Now I need to be able to include that match's data in a main database that maintains and calculates ongoing stats for each player and for each team.

I have attached a completed score sheet.


200109 score sheet.JPG

Link to comment
Share on other sites

This topic is 4398 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.