Thanks for your wisdom. Actually, I was hoping to avoid the recursiveness of the query, and speed up retrieval, by using ikegami's idea of an "all ancestors" table at Re: Tree Structure and Db. But your advice on the nuts and bolts of the interface, and assurance that it is doable, are appreciated.