Hi,

> Thanks for your fast response.
>
> Do you think if we set-up a table named contacts, containing,
> name_id

contact_id

> firstname
> surnmae
> dateofbirth
>
> Above table would contain names for players, mother and father. Then
> somehow, create another table to link player with mother and father.
> Is it possible?

The do:

PLAYER
--
PlayerID (link to Contact.ContactID)

PARENTS
--
ParentID (link to Contact.ContactID)

PLAYER_PARENTS
--
PlayerID (link to PLAYER.PlayerID)
ParentID (link to PARENTS.ParentID)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com