Creating a Registration Setup

[BrianF]

Hi Everyone,



I am completely new to designing dbs, so please bear with me.

I am creating an athletics management database, where users can register an athlete into a sport, or for tryouts for a sport. I have one table that has all of the athletes and all their information. Sports are created by entering information into a form, using several lookup fields for the year, gender, level and season.

My questions are:
1- what is the best way to create the sport
2- what is my best option to "register" an athlete into a sport.

I would somehow like to register multiple athletes into the tryout for the sport, and then after tryouts, move those who make the team onto the sport, so rosters can be printed (a report that would be generated from a querey or table).

I am open to suggestions, from multiple angles of attack.

[June7]

For starters, review these 'sticky' thread tutorials here http://forums.aspfree.com/microsoft-access-help-18/

Design a schema as best you can, post it for analysis.

[rpeare]

Most importantly make sure all your tables have unique identifiers (autonumber works fine). This is likely what I would have.

Participant table for all the people trying out/on teams
Sport table for the type of sport, football, baseball, basketball etc.
Team table for the team names

From here it really depends on how your tryouts are performed. Are kids trying out for a specific team or is it a pool tryout and teams pick kids from that pool

Is it important to know which kids came out for which tryouts and whether or not the made a team? Is it important to know which kids were on which team from year to year or are you going to want to basically re-create teams from season to season?