Help on MYSQL Table design
| From: | John | Date: | Sun, 29 Apr 2001 12:57:48 +0000 |
| Subject: | Help on MYSQL Table design | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-7123@lists.php.net to get a copy of this message | ||
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.