I did a quick look at your solution and it is obvious, that you know about
as much about golf as you do about Access.
1) You would actually create a design that included gender and age as a
single boolean field? If you had actually read the specs you would have seen
that the maximum handicap was 36 no matter what age or gender. (a two stroke
cap on 18 holes is a max of 36). So the only check would be for male older
than junior.
2) You want a table for each hole? The holes are numbered 1 to 18 a single
record would have been adequate.
3) No structure for a round? You need a record with a score for each of the
eighteen holes. The actual par round for the course can be entered into this
table.
4) Why a table of ScoreByHole? Are you expecting them to go out and play
only the odd holes?
5) You also only need to calculate based on the total score for a round, not
on the individual holes.
To begin describing how this works, you did not describe how handicap is
calculated if a golfer hasn't played three rounds. So, you need to figure
out how to compute a golfer's initial handicap and then enter that into
the Handicap field in TblGolfer.
The initial handicap is zero. Once he has played a round, his handicap is on
the way to being established. It's the average, so it does not make a lot of
difference if it is 1, 2 or 3 rounds.
You then need a subform in this subform based on TblScoreByHole.
Can we say overkill?
When you are entering a round and recording the scores on each hole in the
subform based on TblScoreByHole, you need some VBA code records the
difference between the score and par if it is less than 2 or records a 2
if it is equal to or greater than 2. The handicap for a round can be
calculated at any time by summing the HoleHandicap for the round so you do
not need to record the handicap for the round.
Let's make it difficult so we can charge more. We should also store a
calculated field like HoleHandicap in a table. Right steve, YOU are the
expert.
All that is required is to store the raw unadultered scores.
In this procedure you would account for the max handicap for a woman or
junior to be 36 and just 28 for a man.
As I pointed out, the maximum handicap is already 36, so you only need to
cap for non junior men.
Ony key question you missed was whether rounds at other courses count. This
can easily be handled by adding extra records to the rounds table
representing the pars for other courses.
John... Visio MVP
