Hi, I'm designing a simple family tree db which is at present just a flat table In which each record everyone has a father & mother, a variable number of wives,and variable number of children. The links to other family tree members is always the record_id of another record.
At present I'm manually inserting the "links" eg my father is record_id 52, my mother recordid 60 my children records 100,101,102 I can write queries to display everyone's father mother children etc no problem. * But My question is Is it possible/useful to define any sort of relationships/linking the wife/father/mother/children fields and the recordid of other records I'm fogging on this, your advice pls -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
