Direct Ancestors - Dad

Objective:

List the lineage of family members for each branch of fathers side of the family.

Conclusion:

See below.

source

Ancestro Chart

Gaffey	Morgan	Mulvaney	Mulvany
Quinn	Smith

Gaffey

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
2	Portrait	5-3	Clara Mulvaney	1903	1995	4-1	William Gaffey	1882	1946
4	Portrait	9-5	Julia Quinn	1851	1919	8-2	John L Gaffey	1841
8	Portrait	17-1	Ann	1818		16-1	Michael Gaffey	1804

Top

Morgan

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
21	Portrait	43-1	Margaret Munday	1780	1857	42-1	Patrick Morgan	1770	1862

Top

Mulvaney

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
5	Portrait	11-1	Martha Smith	1865	1937	10-3	John Mulvaney	1854	1933
10	Portrait	21-1	Mary	1809	1892	20-1	Jas Mulvaney	1807

Top

Mulvany

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
20	Portrait	41-1	Bridget	1788		40-1	Dominick Mulvany	1785

Top

Quinn

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
9	Portrait	19-1	Julia	1815		18-1	Patrick Quinn	1818

Top

Smith

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	FATHER_ID	FATHER	BORN_	DIED_
11	Portrait	23-1	Emmogene Spaulding	1815	22-5	Joseph Smith	1835
11	Portrait	23-1	Emmogene Spaulding	1815	22-5	Joseph Smith	1845	1916
22	Portrait	45-2	Martha Hall	1815	44-5	George Smith	1810	1869

Top

SELECT IIF(LEN(ALLTRIM(FA.SURNAME))=0,'x', ALLTRIM(FA.SURNAME)), FLOOR(VAL(FA.FAM_ID)) FAMI_ID,padr('<A HREF="http://www.gystdoit.com/famed/portrait-main.php?famid='+ALLTRIM(FA.FAM_ID)+'"> Portrait</A>',250,' ') Portrait, FA.MOTHER_ID , FA.MOTHER , IIF(YEAR(FM.BORN)>0,SPAN(STR(YEAR(FM.BORN),4,0),FM.POB ),SPACE(50)) Born, IIF(YEAR(FM.DIED)>0,SPAN(STR(YEAR(FM.DIED),4,0),FM.POB ),SPACE(50)) Died ,FA.FATHER_ID , FA.FATHER , IIF(YEAR(FC.BORN)>0,SPAN(STR(YEAR(FC.BORN),4,0),FC.POB ),SPACE(50)) Born_, IIF(YEAR(FC.DIED)>0,SPAN(STR(YEAR(FC.DIED),4,0),FC.POB ),SPACE(50)) Died_ FROM C:\JPG\FAMILY.DBF FA, C:\JPG\FAM_MEMBER.DBF FM, C:\JPG\FAM_MEMBER.DBF FC WHERE FM.IND_ID=FA.MOTHER_ID AND FC.IND_ID=FA.FATHER_ID AND FAMSIDE(FA.FAM_ID)='F' AND LEN(ALLTRIM(FA.FAM_ID)) < 3 order by 1,2

SOURCE
URL:	,
Organization:
Date Acquired:	Saturday February 16th, 2019 3:00 AM
Prepared By:	John Gaffey
Last Updated:	Saturday February 16th, 2019 3:00 AM