RE: table layout structure

2004-07-08 Thread SGreen
Fax to: 07/08/2004 01:42 Subject: RE: table layout structure

RE: table layout structure

2004-07-08 Thread bruce
ityID requires that i now duplicate data within the system... which i want to keep to a minimum!!! thanks.. -bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:13 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: table

Re: table layout structure

2004-07-08 Thread SGreen
Bruce, It all depends on what you are storing in foo1 and foo2. For a one-to-many relationship, you need to have that ID column in your child table to reference the parent record. The "classic" example of a one-to-many relationship is Companies to Employees. In the real world there are som