You're welcome.

>Thanks a lot.
>You saved my time. Now I'll restructure the database to get the desired result.
>Thank you once again for your valuable time and advice.
>Regards
>Prashant
>
>>VFP does not support hierarchical queries. You'll have to do that using procedural code.