>>> It is not as easy as that because the level of depth can be anything and for each level one needs a join condition. That's why I could not think of a way to create a sql view to retrieve the data
>
>I know <s>, I own the books I recommended. You need different SQL statements to poll different levels of hierarchy. I don't think there is a way around that. You can use a UNION to append data form different result sets...
>
>With VFP and macro expansion it's pretty easy to create SQL statements on the fly. And keep executing until you get no more new results.
>
>
>Andre
I don't have to feel badfor not being able to come up with a way to have a view show the data
Peter Cortiel