www.gystdoit.com/family/family_gps_tale_of_2_tables.htm

Friday December 23rd, 2016 3:49 PM

Family GPS Tale of 2 Tables

Objective:

Note the basic data collected for genealogy

family

mother
father
wedding date

individual

Name
Date Of Birth
Gender (M/F)
RIP Date

and how they are addressed by Family GPS (aka Family Passport)

Conclusion:

Most family software adopts GEDCOM standard for record keeping
i.e. the software will read and write to GEDCOM format
Family GPS implements these data sets as

Family	equals	Fam_Member	Query Result
FAM_ID	=	FAM_ID	List all the Children in the Family List the Spouse who married into the Family
FATHER_ID	=	IND_ID	Look up personal data about the Father of this Family
MOTHER_ID	=	IND_ID	Look up personal data about the Mother of this Family

Family ID (FAM_ID) and Family Member ID (IND_ID) values can be determined using Family GPS mapping

Family GPS
Family and Family Member Data Tables

Family Record
(Family.dbf)

FAM_ID	2
SURNAME	Gaffey
FATHER_ID	4.10
FATHER	William Gaffey
MOTHER_ID	5.40
MOTHER	Clara Mulvaney
WED_DATE	06/16/1930
PHOTO	William_Gaffey_and_Clara_Mulvaney_wedding.jpg

Family Member Record
(Fam_Member.dbf)

FAM_ID	5
IND_ID	5.40
GIVEN	Clara Mulvaney
BORN	07/22/1903
DIED	04/16/1995
NOTE
MALE	False
MARRIED	Clara Mulvaney Gaffey
OBIT	Clara_E_Gaffey_5-40_obit.jpg
PHOTO	Clara_Mulvaney_5-40.jpg