Hi All,


I have recordset that contains a hierarchical representation of records
where a record's [parentid] field contains the recid of the record 'above'
the current record.


A representation might look like this:


Recid, parentid, title


1, 0, Top level record

2, 0, Another top level record

3, 1, A record under the top level record

4, 3, Another level

5, 2, A record under the second top level record


If I have currently retrieved the record with recid of 4, I want to work out
the 'chain' of records that lead back to the top level record it has been
created under.


In this instance, that chain would look like:


4, 3, Another level

3, 1, A record under the top level record

1, 0, Top level record


I'm wondering if anyone can help me work out how to achieve this?


Many thanks in advance!


Much warmth,



 <http://www.planetthoughtful.org/> http://www.planetthoughtful.org

Building a thoughtful planet,

One quirky comment at a time.


Reply via email to