table setup for horseshoe league scores

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.
 
K

KRosier

Actually, no. The post under the gettingstarted newsgroup was asking if
anyone knew of a fully developed database. This post has specific
questions so that in the event there isn't a completed database out
there, I can get started on my own. I didn't think that tabledesign
would be the place to ask for a complete database.

My apologies if this seemed to be multi-posting, but in reality it's
really two different questions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top