[AccessD] 'Heirarchal Recursion':

I've inherited a 15MB engineering _fe A2K DB with single level product
structures for manufactured assemblies.  I need to create an
'indentured' multi-level bill of material (BOM), presumably using
recursion.  I used to have an article from 'Access-VB-SQL' mag some time
back called 'Heirarchal Recursion' (I think) but can't locate it now.

Any ideas?  Best Sources on the web?
TIA,
Ron Moore
Sr. Database Administrator
Comtech PST Corp.
Melville, NY
www.comtechpst.com