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

On Thu, 22 Feb 2007 18:14:18 -0600, "Cliff Chapin" <ccchapin (AT) cox (DOT) net> wrote:

That would depend on how your tables are related. Typically you'd use a Primary Key field (for example, an Autonumber)
in this scenario, since there will be a lot of duplication among last names. If that's the case, then you'd simply store
the Autonumber PK of the Parent record with the Child record ... then relate you mainform/subform on the
Parent.IDField/Child.ParentIDField
Scott McDaniel
scott (AT) takemeout_infotrakker (DOT) com
www.infotrakker.com