Re: Help on MYSQL Table design

John, No, you could just add another link table. So you would have the following tables: personal_info ------------------------------ ID -> unique id for family member NAME -> family members name family_info ------------------------------ ID -> unique id for family F_NAME -> family name personal_family_link ------------------------------ P_ID -> comes from personal_info.ID F_ID -> comes from family_info.ID RELATIONSHIP -> family members relationship All of these fields would be required (NOT NULL). Toby ----- Original Message ----- From: "John" <frizzy1994@hotmail.com> To: <php-windows@lists.php.net> Sent: Sunday, April 29, 2001 8:57 AM Subject: [PHP-WIN] Help on MYSQL Table design > Hi Everybody, > > I have 2 tables: personal_info and family_info. > For example, in personal_info, I have ID and NAME as fields. In > family_info, I have ID, F_NAME and RELATIONSHIP as fields. > > The problem is in family_info, for each ID, I have several records. Do I > need to have another field, say, COUNT in family_info so that I > associate these records to each ID? > > > Thanks. > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >