>>I'm particularly interested in how the database tables would be structured and related..
Actually, this is fairly simple. Basically you just need two table: 1. individuals, in which each person has a field "parentsId" ... plus dates, places, comments, etc. 2. parents in which each record has FatherId and MotherId pointing to the individuals table, plus date, place etc. For building trees, you need recursive tags. You cannot use standard date types, because you need dates like "about 1850" or "May 1850", or even "before May 1850 and after Jan 1848". You need to store then in text fields. So searching by date kind be rather tricky. I've made my own system for my family, but the site is not public. It is a combination of a photo album (more than 1040 photos), a genealogical (22786 persons) database and coats of arms (469 arms). -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
