Design Question

[grahamee]

Hey - I'm new to Access. I am using it to maintain registration for a sports team. I run 4 seasons throughout the year and I want to keep track of which athletes participate in which season.



I am creating a table for contact information. Should I create separate columns for all the seasons (F09, W09, Sp10, Su10, etc)? Is there a more streamline way to do this?

Thanks for the help!

[ConneXionLost]

Ultimately, it depends on what you want to do with the information, but if you're also doing this to learn about databases, then you'll want to Normalize your data.

Consider a seperate table "tblSeasonPlayed":

SeasonPlayedID (PK)
ContactID
Season

With data something like this:

SeasonPlayedID	ContactID	Season
0	3	W09
1	6	Su10
2	2	F09
3	8	Su10
4	2	Su10

Cheers,

[TheShabz]

If an athlete can participate in multiple seasons, you'll want 3 tables.

One for the athlete information
One for season information
a third (the one by conneXion) to facilitate a many-to-many relationship between the previous two tables.