Im trying to set up a couple of tables to keep track of football
stats for a pool I'm in.
This is more of a learning exercise for me than an important data
collection, but its been driving me nuts because I just can't get it to do
what I want.

tblTeams fields :

**Teams - Just a listing of every team
Name1- Check box field to show what teams have already been picked by who
Name2-~
Name3-~

tblGames :

****ID
**Home Team
Away Team
Home Team Win-Check box to show who won
Home Team Score
Guest Team Score

tblSeason:

****ID
Week
Year

tblTeams.Teams linked to tbleGames.Home Team
tblGames.ID linked to tblSeasons.ID

I want to be able to do a query or report that, for each team, will show
every game they have been in (as either Away or Home Team)
The way it is now, all I can get to come up are the games in which the
selected team is the Home Team.
Can anyone give me any advice as to how this should be done please?
I know its probably a simple solution, but I just can't find it! (and I've
tried about 10 different configurations!)

Thanks in
advance - Sean

You need to edit your relationships and add in the relationship
between the team names and visiting team

tblTeams.Teams linked to tbleGames.Visiting Team

Good Luck,

John



"What-a-Tool" <What-a-ToolNoFreakinGroundUpMysteryMeat (AT) cox (DOT) net> wrote

I've already tried this. Maybe I'm just doing something stupid?
Created a relationship between my primary key [tblTeams.Team] and
[tblGames.HomeTeam]. Then added another relationship from [tblTeams.Team] to
[tblGames.AwayTeam]Now, another representation of tblTeams shows up in the
relationships display, this one called tblTeams_1
Looks good.
Yet, when I do a query by team to show all games in which this team has
played, only the ones in which this team was the home team show up.
Or when I expand the tblTeams child table link, same thing -only the games
in which this team played at home show up.
(I have been able to get it to show by Away team games also, but never
both.)



"janthony" <janthony (AT) harrahs (DOT) com> wrote