Then again I think you actually have a many to many relationship here. So you need a join table. That gives you ultimate flexibility.
Adam > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 31 October 2003 16:05 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] one-to-one relationship > > > Thanks Colm - that has good reviews on Amazon - I might get that > > _______________________________________________________ > * Regards, > Richard Lovelock > Westminster City Council - Web Support > Cap Gemini Ernst & Young > Southbank > 95 Wandsworth Road > London > SW8 2HG > ( 0870 906 7482 > > _______________________________________________________ > > > -----Original Message----- > From: Colm Brazel [mailto:[EMAIL PROTECTED] > Sent: 31 October 2003 16:00 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] one-to-one relationship > > > 'Database Design for Mere Mortals', Hernandez, good for pondering these > issues > > -----Original Message----- > From: Aidan Whitehall [mailto:[EMAIL PROTECTED] > Sent: 31 October 2003 15:53 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] one-to-one relationship > > > No.... he's right -- you need a table per entity but with an > intermediary table binding teams to pitches > > Teams > TeamID > Team > etc > > | > > TeamPitches > TeamID > PitchID > > | > > Pitches > PitchID > etc > > > That gives you the flexibility to handle teams that share pitches. > Obviously, put a uniqueness constraint on TeamID-PitchID in the > intermediary table. > > > -- > Aidan Whitehall <mailto:[EMAIL PROTECTED]> > Macromedia ColdFusion Developer > Fairbanks Environmental Ltd +44 (0)1695 51775 > Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> > > ________________________________________________________________________ > This e-mail has been scanned for all viruses by Star Internet. The > service is powered by MessageLabs. For more information on a proactive > anti-virus service working around the clock, around the globe, visit: > http://www.star.net.uk > ________________________________________________________________________ > > -- > ** 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] > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 > > > -- > ** 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] > > > ======================================================= > This message contains information that may be privileged or > confidential and is the property of the Cap Gemini Ernst & Young > Group. It is intended only for the person to whom it is > addressed. If you are not the intended recipient, youare not > authorized to read, print, retain, copy, disseminate, distribute, > or use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and delete > all copies of this message. > ======================================================= > > > -- > ** 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] > > -- ** 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]
