[AccessD] Hierachical Recursion (was: 'Heirarchal Recursion')

Hi Ron

Look up "Tree shaped reports" in the archives from Feb. 2002 for a
method running at extreme speed ...

/gustav


> 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