Note the format and record count of the recently modified Family.dbf table used in Family Passport application fpp.exe
Conclusion:
The newly formatted Family table was migrated to production today.
We have accounted for 248 families thus far [Note: Several Family.dbf records have no meaningful data; they serve as place holders to support query joins with FAM_MEMBER.dbf
There are many other records with missing bits of info - eg. WED_DATE, MOTHER surname]
Fam_ID was changed from numeric to character format to support parenthetical notation for families with over 9 children.
e.g. Haley Family descendants, FAM_ID=7, for child 1 through 9, FAM_ID = 701 through 709
For the tenth child FAM_ID = 70(10)
This would work well for tracing descendants of ancestor families with double digit FAM_IDs.
i.e. Descendants of FAM_ID=11 would be FAM_ID=(11)01 through (11)09
Currently we only track descendants for Ancestor families FAM_ID =1 through 7
