K
Keen Aussie Golfer
Hi all
relatively new to access (and database design) but want to create a db to
track key golf stats for myself such as Fairways hit, Greens in Regulation,
No. Putts, Sand Saves.
I think I am on top of most of the table design/relationship but am unsure
how to set up Fairways Hit and Sand Saves. ie. With Fairways Hit I set the
field as yes/no but of course a par three should not even allow this option.
So too with the Sand Saves if you never actually ended up in a greenside
bunker.
In essence, I have a table named tblHolePlayed which includes the Fairways
Hit & Sand Saves fields. Can the yes/no field property handle the three
options via a null entry or is there a better way.
Thanks
Keen Aussie Golfer
relatively new to access (and database design) but want to create a db to
track key golf stats for myself such as Fairways hit, Greens in Regulation,
No. Putts, Sand Saves.
I think I am on top of most of the table design/relationship but am unsure
how to set up Fairways Hit and Sand Saves. ie. With Fairways Hit I set the
field as yes/no but of course a par three should not even allow this option.
So too with the Sand Saves if you never actually ended up in a greenside
bunker.
In essence, I have a table named tblHolePlayed which includes the Fairways
Hit & Sand Saves fields. Can the yes/no field property handle the three
options via a null entry or is there a better way.
Thanks
Keen Aussie Golfer