Baseball League Database

[GoBruins]

hi,

i'm a relative newbie to Access and databases in general, so please bear with me.

i'm trying to build a database that will keep track of Little League Baseball data. i've created the table for the Teams - that was pretty straightforward.



i'm now trying to design a table that will keep track of game scores and the resulting wins and losses for each team. this is what i have so far in terms of fields:

////////////////
GameID
Date
HomeTeamID
AwayTeamID
HomeTeamScore
AwayTeamScore
///////////////

is this all i need? what's the methodology of assigning Wins and Losses for the teams? are there other fields that i can add that will make reporting data easier? ultimately, i'm looking to summarize Wins and Losses in some type of report or query in this fashion:

Team Name Wins Losses Ties
----------- ----- ------ -----
Panthers 2 0 0
Tigers 0 2 0

etc...

thanks in advance.

[GoBruins]

so i got to thinking - should i add a couple of additional fields:

WinningTeamID
LosingTeamID

that way, i would have to do less programming/coding when it came to reporting wins and losses? i realize this may not be the cleanest and leanest way to do it, but since i don't have a lot of experience programming...