K
KathyR
Hi Folks!
I'm trying to set up a database to keep track of scores for a horseshoe
league (scored very similarly to a bowling league). I'm using Access2000
and have rudimentary knowledge of VBA - enough to know I can do what I want,
but it takes me forever to get there. Your help would be very much
appreciated.
Kathy
Two questions:
1) Should I have a separate table to contain the game scores?
2) How do I keep track of team scores when there is a substitute? i.e. Bob
substitutes on team 1 the first week and team 2 the second week. How/where
would I store the information about which team he subbed for, for which
week. I hope this makes sense, and I'm sure the answer is staring me in the
face, but I'm having a mental block at the moment.
TABLE SETUP
tbl_team
teamID
team_no
team_name
tbl_team_members
teamMemID
teamID
playerID
tbl_player
playerID
Fname
Lname
substitute
tbl_stats
statsID
playerID
gm_date
game1 (score for game 1)
game2 (score for game 2)
game3 (score for game 3)
gms_played (number of games played per date)
shoes_thrown (number of shoes thrown per date)
ringers (number of ringers thrown per date)
One team can have many players
A player can be on only one team, except for subs. Subs can be on many
different teams over the course of the season, but on only one team per game
date.
A player can play 1, 2, or 3 games per game date (gm_date).
I need to be able to distinguish between games 1, 2, and 3 so that I can
figure out high individual game, high team game, etc.
I'm trying to set up a database to keep track of scores for a horseshoe
league (scored very similarly to a bowling league). I'm using Access2000
and have rudimentary knowledge of VBA - enough to know I can do what I want,
but it takes me forever to get there. Your help would be very much
appreciated.
Kathy
Two questions:
1) Should I have a separate table to contain the game scores?
2) How do I keep track of team scores when there is a substitute? i.e. Bob
substitutes on team 1 the first week and team 2 the second week. How/where
would I store the information about which team he subbed for, for which
week. I hope this makes sense, and I'm sure the answer is staring me in the
face, but I'm having a mental block at the moment.
TABLE SETUP
tbl_team
teamID
team_no
team_name
tbl_team_members
teamMemID
teamID
playerID
tbl_player
playerID
Fname
Lname
substitute
tbl_stats
statsID
playerID
gm_date
game1 (score for game 1)
game2 (score for game 2)
game3 (score for game 3)
gms_played (number of games played per date)
shoes_thrown (number of shoes thrown per date)
ringers (number of ringers thrown per date)
One team can have many players
A player can be on only one team, except for subs. Subs can be on many
different teams over the course of the season, but on only one team per game
date.
A player can play 1, 2, or 3 games per game date (gm_date).
I need to be able to distinguish between games 1, 2, and 3 so that I can
figure out high individual game, high team game, etc.