I trying to design a table to store golfscorecards in, but I just can't
get up with a good design.
Does anybody have any experience in designing scorecard tables.
I want to have 1 record per 9 holes. One hole has 3 different distances, and some more values like par, difficulty, ID etc.
Frist thing what comes to mind is to create 9 x 3 = 27 fields just to store
the distances, somehow this doesn't look like a good design to me.
Is it possible to store arrays in a field or something so I can store 3 distances in
one field.
I Hope someone has some design tips !
get up with a good design.
Does anybody have any experience in designing scorecard tables.
I want to have 1 record per 9 holes. One hole has 3 different distances, and some more values like par, difficulty, ID etc.
Frist thing what comes to mind is to create 9 x 3 = 27 fields just to store
the distances, somehow this doesn't look like a good design to me.
Is it possible to store arrays in a field or something so I can store 3 distances in
one field.
I Hope someone has some design tips !