Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2003
    Posts
    7

    Unanswered: Lineage / hierarchy

    I want to sound you all out about the most efficient way to achieve something...........

    I need to implement a parent/child type relationship and be able to query so I can easily build a graphical representation. Now, its a little different that normal because the selection of child drives the tree building process: so given a child's name I want to get all his/her ancestors.

    Like

    Me
    ----- My Mom
    --------- Her Mom
    ------------ Her Mom
    ---------------- .....etc.
    ------------ Her Dad
    ---------------- .....etc.
    --------- Her Dad
    ------------ His Mom
    ----------------.....etc.
    ------------ His Dad
    ----------------.....etc.
    ----- My Dad
    --------- His Mom
    ------------ Her Mom
    ----------------.....etc.
    ------------ Her Dad
    ----------------.....etc.
    --------- His Dad
    ------------ His Mom
    ----------------.....etc.
    ------------ His Dad
    ----------------.....etc.

    To simplify: instead of each parent having one or more children (usual tree structure) I want to represent each child(person) having 2 parents!!

    Any idea? It actually gets a little more complicated but help with this would be a great start.

    Thanks
    Last edited by jhx; 09-05-03 at 07:27.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •