Can anyone help?

  • Thread starter Thread starter Simon Yee
  • Start date Start date
S

Simon Yee

Hi, I have this form for a database for a family records.

Let's say the parents and the kids

How I have a subform in the access database which the parents name is always
link with the kids name ?


Any help would be appreciated.

Thanks
 
Simon said:
Hi, I have this form for a database for a family records.

Let's say the parents and the kids

How I have a subform in the access database which the parents name is
always link with the kids name ?
Click to expand...

It depends on how detailed you want to make it.
The simple answer is two tables, one with parents and one with kids. Relate
them by adding kids to a subform on the parent's form.

But that can cause problems when you come to grandkids and each parent
should have a separate record because these things change.

What ever you do don't use the last name as a key.
 
Hi, I have this form for a database for a family records.

Let's say the parents and the kids

How I have a subform in the access database which the parents name is always
link with the kids name ?


Any help would be appreciated.

Thanks
Click to expand...

The Name is not a reliable link. You very well might have two people
in your table, both named Robert Lee, both of whom have children, but
they are different people with different children!

Your "Family" table should have a FamilyID, perhaps an autonumber, as
a Primary Key; the Children table should have a FamilyID field of the
same datatype (Long Integer for an Autonumber) as a link to that
primary key. If you use a Form based on the family table, with a
Subform based on the children table, using FamilyID as the
master/child link field, you'll maintain the linkage as you wish.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top