Seeing the other tree question made me think of something I have been curious about: how to build trees from ZSQL methods. I have a MySQL table of cars with car-common fields: YEAR, MAKE, MODEL, BODYTYPE, COLOR, etc. What I would like to do is have a tree showing the words as above like this: +YEAR +MAKE +MODEL ...etc Expanding the word YEAR would show a list of distinct years with maybe a count of cars for each year. Same concept for the others top levels. +2002 (57) +2001 (39) +2000 (43) ...etc Expanding the actual YEAR would show all MAKEs (and counts) for that YEAR. Same concept for the other criteria. How would the tree code look for doing something like this? And the ZSQL methods? Pointers or links to available material would be appreciated. Thanks Allen