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?
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?