|
Divisions form: Here you can select, enter, modify and delete divisions. Upon selecting a division you can select, enter,
modify and delete teams. Team payment and tavern selection can be done here. After selecting a team you can
select, enter, modify and delete players.
Taverns form: Here taverns can be selected, entered, modified and deleted in each division.
Perfect Schedule form: A perfect schedule can be made by pressing one button! All teams play each week and meet each other
twice: once "HOME" and once "AWAY".
Bad Matches form: After creating a "Perfect Schedule" it is possible that too many teams of same tavern play at home
on a playing date. These matches are classified as "Bad Matches". This means there are not enough tables available
in that specific tavern. "Bad Matches" are ordered by division, date and tavern. The AWAY tavern with most tables is on top.
Simply press the swap-button. HOME and AWAY team will be swapped.
Scores form: Select division and playing date. All valid matches are displayed, select a match and enter the scores. Scores can be edited and deleted as
well
Prepare next year form: Prepares the database for next year's league by pressing one button! It will clear all payments, delete all scores and delete
all games.
Update_Teams_Initial_Payment query: updates payment due for each team. Computed by payment amount for each team and each player within that team.
Teams_Debt query: Displays all teams that have not paid everything yet (and teams that paid too much as well). It displays all details why teams
should pay that amount of money.
Teams_CountTLne1 query: Displays all teams without a team leader, or with more than one team leader.
Matches_Not16Games_inPast query: Displays all matches that don't have 16 games in database. Only past games are listed.
|
