Family Tree - FAM_ID: 309

FAMILY.DBF Contents

SELECT FAMILY.FAM_ID , FAMILY.SURNAME , FAMILY.FATHER , FAMILY.MOTHER,FAMILY.WED_DATE FROM C:\JPG\FAMILY.DBF FAMILY where SUBSTR(ALLTRIM(STR(FAMILY.FAM_ID,10)),1,3)='309' ORDER BY FAMILY.FAM_ID

FAM_MEMBER.DBF Contents

309 - Greg Mccoy & Rose Marie Dunn

IND_ID	NAME	AGE	BORN	NOTE	EXP_7
309.01	Greg Mccoy	65	09/08/1950
309.10	Heather McCoy (Heather Blackiston )	39	08/10/1976
309.20	Patrick McCoy	36	11/23/1978

3091 - Tom Blackiston & Heather McCoy

IND_ID	NAME	AGE	BORN	NOTE	EXP_7
3091.01	Tom Blackiston	38	05/13/1977
3091.10	Haley Blackiston	2	12/24/2012

3092 - Patrick McCoy & Kim Slasinski

IND_ID	NAME	AGE	BORN	NOTE	EXP_7
3092.01	Kim Slasinski (Kim Mccoy )	36	02/06/1979
3092.10	Cianan Patrick McCoy	5	07/20/2010
3092.20	Peyton James McCoy	0	02/23/2015

SELECT STR(FAM_MEMBER.FAM_ID,5)+' - '+ALLTRIM(B.FATHER)+' & '+ALLTRIM(B.MOTHER), FAM_MEMBER.IND_ID , FAM_MEMBER.GIVEN +IIF(LEN(ALLTRIM(FAM_MEMBER.MARRIED ))> 2,' ('+FAM_MEMBER.MARRIED+')',' ') Name, AGE2(FAM_MEMBER.BORN,FAM_MEMBER.DIED) Age ,FAM_MEMBER.BORN ,padr(IIF(FAM_MEMBER.DECEASED,'RIP '+DTOC(FAM_MEMBER.DIED),''),250,FAM_MEMBER.NOTE) Note, padr('<img src="'+ALLTRIM(FAM_MEMBER.FILE_ID)+'.jpg" height=80 >',250,' ') FROM C:\JPG\FAM_MEMBER.DBF FAM_MEMBER, C:\JPG\FAMILY B WHERE B.FAM_ID=FAM_MEMBER.FAM_ID AND SUBSTR(FAM_MEMBER.IND_ID,1,3) = '309' ORDER BY 1,2