Or you could just move over to Oracle, which has built in support for hierarchical trees... http://www.oracle.com/technology/oramag/webcolumns/2003/techarticles/gennick_connectby.html But that may not be a possibility :o) Mark On 8/3/05, Judah McAuley <judah at wiredotter.com> wrote: > There is a pretty decent (in my opinion) overview of working with > hierarchical data on the Evolt site: > http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/index.html > -- E: mark.mandel at gmail.com W: www.compoundtheory.com ICQ: 3094740