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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
