I have a real challenge

  • Thread starter Thread starter cshafer
  • Start date Start date
C

cshafer

Up to a challenge
I have a database that is used as an interface/data input tool fo
school sports schedules

I have 2 combo boxes. The first is for the school schedule that i
being input. The second is for the opponent for the game. In othe
words, it looks like this:

GameDate SchoolName Opponen

The problem

For every game input for a particular school, I want a new game t
automatically be added to the "Opponent" school, so when you pull u
the opponent school name, that game will already be in the schedul
for the opponent school

The game is in the table, but the problem is that when you pull up th
opponent name as the school name (to view their schedule), the game i
not in there. I don't want a person to have to put in the same game
for the school and then the opponent. What can I do
 
I would create a game that has only one record.
GameDate, HomeTeam, VisitingTeam
There should be no need to have more than one record per game.

If you want to be more sophisticated, you can have a table of games and a
table of game participants:

tblGames
================
GameID
GameDate
GameTime
GameLocation

tblGameTeams
===============
GameTeamID
GameID (relates to tblGames.GameID)
TeamID (relates to tblTeams.TeamID)
TeamScore
.....

This would allow for triangular meets and other types of contests involving
more than 2 teams.
 
Back
Top