microsoft Access templates

[Michael]

can anyone assist me in making a Golf Start List programme?
each day i need to enter some 150 players in groups of 3 or 4 at tee off
times from 0800hrs and at 8min intervals thereafter. the problem is entering
the handicaps. each person has their own (changing) handicap, however as each
course is graded for dificulty (called Slope) we need to refer to a table to
find the players handicap for each course. we have two courses, north and
south. the differnce is set in a list. so if a 10.4 handicap player plays the
south he is given a playing handicap of say, 11.5 for the south cours and
say, 9.6 for the north course.
at the end i need a list to put on the board showing all the groups playing
and list their handicap for the Day /(course). some of the games we play ask
us to add all four playing members handicaps together and divide by 4 (or
10%) etc.
if anyone can assist 150 members will be eternally grateful

 

[Ed Robichaud]

Can't do your whole app, but to get you started, I recommend a minimum of 5
tables.

tblPlayers
PlayerID autonumber -primary key
Lastname
Firstname
Handicap
etc.

tblCourse
CourseID primary key
CourseName
Factor
etc.

tblGame
GameID primary key
CourseID foreign key -relate to tblCourse
Date
etc.

tblFoursomes
FoursomeID
PlayerID foreign key -relate to tblPlayers
etc.

tblGameStart
FoursomeID foreign key -relate to tblFoursome
GameID
Time
CorrectedHandicap
AvgFoursomeHandicap (not advised to store calculated values)
etc.

-Ed

 

[Michael to Ed]

Edmany thanks for your kind assistance, not sure i understand all the answer,
but will try to do it.