B
BruceWil
Hello All,
I am having a terrible time with trying to make a baseball database which
tracks Teams, Games, Rosters and Stats.
My biggest problem is designing the schedule/games and stats part.
I have a tables like the following:
Teams
Rosters
rosterid
teamid
playerid
Last....
Schedules
scheduleid
teamid
Homegame (Y/N)
Opponet
Date, time, etc
GameStats
statsid
scheduleid
gamestats (which is bascially a box score)
PlayerStats
playerid
teamid
scheduleid
playerstats (like hit, runs, etc).
The problem is figure out how to do the schedule and the games without
having to do it twice.
What I want is to be able to see a complete league schedule the games and
results as well as seeing individual schedules for teams.
Right now my schedule works for an individual team but not good for entering
something like a box score which as two teams.
Hope I explain it correctly, can advise? I do not know SQL so need VBA or
drop down help
I am having a terrible time with trying to make a baseball database which
tracks Teams, Games, Rosters and Stats.
My biggest problem is designing the schedule/games and stats part.
I have a tables like the following:
Teams
Rosters
rosterid
teamid
playerid
Last....
Schedules
scheduleid
teamid
Homegame (Y/N)
Opponet
Date, time, etc
GameStats
statsid
scheduleid
gamestats (which is bascially a box score)
PlayerStats
playerid
teamid
scheduleid
playerstats (like hit, runs, etc).
The problem is figure out how to do the schedule and the games without
having to do it twice.
What I want is to be able to see a complete league schedule the games and
results as well as seeing individual schedules for teams.
Right now my schedule works for an individual team but not good for entering
something like a box score which as two teams.
Hope I explain it correctly, can advise? I do not know SQL so need VBA or
drop down help