Family Database ?

[Cliff Chapin]

I am Constructing a family Database and want to know the best way to connect
non last names parents to the shildren a children sub form

[Allen Browne]

The crucial aspect is the everyone (parents and children) must go in the one
table, since children grow up to become parents too.

Once you have that, the next question is how you need to connect them. If
you are tracking only biological parents, a person has just 2 parents, and
you can use a self-join like this:
Self Joins: tables that look themselves up (Pedigrees example)
at:
http://allenbrowne.com/ser-06.html

If you are trying to keep track of other parentage (adopted children, foster
children, step children, ...) things get more complex, and you need a way to
specify which families the person belongs to at any point in time. You might
consider a structure such as this:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

There is not a one-size-fits-all solution.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Cliff Chapin" <cc******@cox.n etwrote in message
news:2y******** ********@newsfe 07.phx...

>I am Constructing a family Database and want to know the best way to
connect
non last names parents to the shildren a children sub form