dlongnecker, I follow...

so essentially using inteteger ID fields is a little more static, or permanent. That is, they are unlikely to change in the future and cause problems, whereas my...

Matt Miller, great suggestion about different seasons.

OleHank, that code is pretty much what I've gone with. Thanks.

As a bit of an aside: why bother having a "TeamID" field? I mean,...

So I think I found a better solution than either of the two proposed:

Solution 3: Create a new table called 'DraftedPlayers' with columns 'FantasyTeamName' and 'PlayerID'. Although I still don't...