This is a very simple question, but something I've never really given much thought before. If you've got two tables with a one-to-one relationship, how do you deal with the foreign keys? e.g. lets say you had FootballTeams and FootballGrounds (and lets pretend there aren't any teams that share grounds). In which table would you store the foreign key linking it to the other table? Or would you duplicate data and store in both. e.g:
Team, GroundID Rangers, 2 Celtic, 3 Hearts, 5 Hibs, 1 Aberdeen, 4 Ground, TeamID Easter Road, 4 Ibrox, 1 Parkhead, 2 Pittodrie, 5 Tynecastle, 3 I'm sure there's a logical rule for dealing with this, but I can't think what it is. Not a very difficult issue, just something I'm pondering. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
