Best way to setup tables?

bozrdang

Registered User.
Local time
Today, 11:18
Joined
Dec 3, 2001
Messages
24
I am trying to build a database for my fantasy football league. I want to be able to enter each team's game score for each week of every season. I have some basic knowledge of Access, but I'm a little stumped on how to setup my tables. A couple variables:

1. Teams might be added or subtracted any given year.
2. There might be a different amount of weeks each season.
3. We currently divide all teams into 2 divisions, but may expand later.

What's the best way to setup my tables for this scenario?
 
Anyone?

What I'm asking is should I have a tblTeams, tblSeasons, tblWeeks, tblGames, etc.? My problem is that they would all be many to many relationships. Anyone have an efficient way to set this up?
 

Users who are viewing this thread

Back
Top Bottom