>>>Check this sample (SQL 2000)
>>>http://beyondrelational.com/justlearned/posts/628/recursive-bom-implementation-for-older-version-of-sql-server.aspx
>>
>>Thanks Naomi, but this is a VFP database.
>
>I believe the code will be very much the same, even simpler in VFP.

OK, I'll see if I can understand all that TSQL stuff.