Hi

I am building a site for a small competition.

There are 16 teams each with 22 players per squad. Each team would play a minimum of three games and a maximum of eight games (depending if they progress to the final etc). The fields that need to be populated for each game are:

Player Name
Player Number (from 1 - 22)
Played (Yes / No)
Sub (Yes / No)
Booked (Yes / No)
Sent Off (Yes / No)
Scored (Yes / No)

Do I need a separate table for each team (ie 16 tables) or do I put all the players in one field / table (and reference with team ID) and then have eight columns (ie game 1, game 2 etc)

This has been bugging me all weekend as I am sure there must be an easier option.

The database initially will be Access 2000.

Cheers

....It's only easy if you know the answer

I would have the following:

Team Table

Player Table (With linked field Team_ID to Team Table)

Game Table

Game Members Table
(This would be made up of:
Game Member ID
Game ID
Member ID)

Let me know offline if you want any more help.



Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting