news <[EMAIL PROTECTED]> wrote on 30/06/2005 16:47:43:
> 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 This is a link, previously recommended on this list, which I have found very useful: http://www.sitepoint.com/article/hierarchical-data-database Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]