Jump to content
Sign in to follow this  
alanfallow

league tables

Recommended Posts

alanfallow

I have been messing about with filemaker pro 7. i used to use dbase many moons ago. I am trying to make a league system which i can input scores every week and update a table. i want the teams sorted obviously.

Is the best way to make different tables and the output is sorted in a report or what would be the easiest way. I have a book on filemaker but would also like a wee bit of help if possible thanks.

Share this post


Link to post
Share on other sites
nhjelmberg

I'd suggest one table for the teams and one table for the scores. In the scores table, use fields for home team, away team (use value lists to select teams), home goals, away goals, home points (calculation field) and away points(calculation field). In the teams table, create calculation fields that counts points, goals and goal difference per team and sort the posts (in a portal or through a script) by points, goal difference and goals. Good luck with the Filemaker, once you get started you learn very quickly!

Share this post


Link to post
Share on other sites
alanfallow

would i need a key field in each table to ling the two tables together.

thanks

Share this post


Link to post
Share on other sites
nhjelmberg

Yes, you need a link between teams (or team ID if you use that). Then each team in the team table will find its scores in the scores table.

Share this post


Link to post
Share on other sites
alanfallow

Hi AGAIN

Think I am getting there.

How do you associate the team in a record with the score of that team

Share this post


Link to post
Share on other sites
Robert Schaub

I don't know how many teams or games you play , but have you seen my

Round Robin?

Share this post


Link to post
Share on other sites
alanfallow

wow that is brilliant exactly what i am looking for. its a hockey league i run in scotland. maybe try a curling system also.

thanks a lot.

Share this post


Link to post
Share on other sites
Robert Schaub

Careful this is only set to 12 maximum teams returning 11 rounds.

Any more than that you modify to make more teams (hard part) or more rounds.

Share this post


Link to post
Share on other sites
alanfallow

there are only about 11 or 12 teams in our leagues here. Will try and do a league table ie games played points, wins draw etc.

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  



×
×
  • Create New...

Important Information

Terms of Use