sql - Recursive Query in MS Access -

sql - Recursive Query in MS Access -

i working on little project in need create recursive query in either sql or vba in ms access 97.

the problem this: trying find related parts in document, example. document number given me. input doc number query , query runs off , finds part numbers associated document, simple enough. next, need find parts associated part numbers on document. there existing database has these relationships, links parts 1 @ time (i provide flowchart of @ end, don't worry). have no problem returning first level related parts, or sec level related parts, of these assemblies can go downwards 30 levels! need recursive way start 0 level part , move downwards final level.

help treeview command appreciated!!

thanks!

flowchart:

document , associated part # db ----> related parts db

sample entry:

associated part table                 related parts tabledocnum | associatpn                  pn1     | pn2100020    654321                      654321  684897100020    123456                      684897  198546100020    987123                      987123  356497

sql vba ms-access recursion ms-access-97