>>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.