I think I may not have asked a specific enough question last time round. I'll try it again. I've been looking through the How-To's and the documentation and the dtml-tree stuff that I have found seems exceedingly cryptic. The closest that I've come to a solution is the following code: <dtml-in "getAllClientNames(REQUEST)"> <dtml-tree id=clientID branches_expr="getClientsForProjects(get_clientID=clientID)" > <dtml-var company_name> </dtml-tree> </dtml-in> where getAllClientNames looks like: select company_name,clientID from client; and getClientsForProjects looks like: select company_name, clientID from client where deleted = 0 and clientID = <dtml-sqlvar get_clientID type=int>; This gives me a tree structure which, when I expand company1 gives me company1 again and again (ie Company1 Company1 Company1 Company1 etc as deep as I care to go Company2 Company2 etc Company3 Company4 What I'm trying to do is list my company name as the tree branch and have the sub headings of each branch be my projects for that company. Can anyone help? Thanks very much Mike Kelland mike@studiomatic.com