Direct Ancestors - Mom (Dunn - Haley)

Objective:

Conclusion:

Bingham	Dunn	Haley	Knittle
Wells	Winchell

Bingham

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
15	Portrait	31-1	Nancy E Winchell	1867		30-1	Frank L Bingham	1863	1914
30	Portrait	61-1	Grace Richards	1838	1896	60-1	George Bingham	1833	1916

Top

Dunn

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
3	Portrait	7-1	Ellen Dorothy Haley	1912	2002	6-4	James Anthony Dunn	1903	1984
6	Portrait	13-4	Nellie Wells	1876	1921	12-3	James Dunn	1868	1957
12	Portrait	25-6	Sarah Merna	1849	1908	24-1	William Dunn	1835	1906

Top

Haley

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
7	Portrait	15-2	Florence Annette Bingham	1891	1971	14-1	William Cletus Haley	1888	1955
14	Portrait	29-1	Mary Knittle Haley	1867	1888	28-1	John Haley	1863
28	Portrait	57-1	Ellen Loftus	1835	1918	56-3	Edward Haley	1833	1899

Top

Knittle

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
29	Portrait	59-1	Mary Godell	1847	1909	58-1	Joseph Knittle	1830

Top

Wells

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
13	Portrait	27-1	Lydia	1842		26-1	Charles Wells	1839

Top

Winchell

FAMI_ID	PORTRAIT	MOTHER_ID	MOTHER	BORN	DIED	FATHER_ID	FATHER	BORN_	DIED_
31	Portrait	63-1	Hannah L Barnes			62-1	Francis Winchill

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)='M' AND LEN(ALLTRIM(FA.FAM_ID)) < 3 order by 1,2

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