I thought this was going to be simple but having read numerous postings on

the

mailing list and all related HOW-TOs I can find, I think I can confirm I am stuck. This is sad because I've just spent a very productive couple of days with Zope and MySQL making the world a better place.

I have a table for chickens. Basically it looks like this

<snip sql>

It would appear that I need to feed two things to the dtml-tree tag. Firstly my starting levels (my types) and then the related data underneath but I can only feed one SQL query to the tag. All the stuff I read seems to assume the info at the top level comes from the same file (and from a key id). How do I do this or indeed, is it possible? I have a nasty feeling I am missing something obvious.

Unless I do not quite understand you I think you missed Anthony Baxter's tree_and_sql howto (http://www.zope.org/Members/anthony/tree-coding-tricks ). It will probably give you either exactly what you want or enough ideas to get you further. hth Rik