Basic Database design

[Mark Scott]

I am looking to create a database with members of a football team with all
their personal details. I would also like a second table where I can put in
the date of the game and give each player in the ist a score for 4 legs of
the game, but I cannot for the life of me work out how to join the 2 tables
together.

Any ideas?

Regards

Mark

 

[KARL DEWEY]

You set a relationship using what is common between the two tables - the
players.
In the player table create a primary key field like MemberID as an Autonumber.

Set up a one-to-many relationship the the Game table.

 

[John Vinson]

I am looking to create a database with members of a football team with all
their personal details. I would also like a second table where I can put in
the date of the game and give each player in the ist a score for 4 legs of
the game, but I cannot for the life of me work out how to join the 2 tables
together.

You need a third table. Since each player will play in many games, and
each game has many players, you need a third table to resolve the many
to many relationship. E.g.

Players
PlayerID
LastName
FirstName
<other bio information>

Games
GameDate
<other info about the game as an event, e.g. location>

Scores
GameDate <link to Games>
PlayerID <link to Players>
Leg <1 to 4>
Score <this player's score for this game>


John W. Vinson[MVP]