Multiple level Bill of Material Explosion - Help please

[xtopia]

Hi Guys
I'm a novice access VBA programmer. I’m trying to write a nested
query
to explode the bill of material. But the BOM table has more than 20
levels. It’s really redundant and annoying to write all those nested
queries in access. my question is, how do I approach this problem to
solve it using VBA. I’ve seen so many vba codes online, but I don’t
seem to understand it well enough to apply it in my situation.
the fields in the BOM table are the Following (Sample).
an item can be a parent as well as a child

The point of the BOM explosion is to Show how many componenets are
required to be a salable Item

ParentItemNumbe r ChildItemNumber QuantityPer
-------------------------- ------------------------
-------------------

1 G1 1

1 G2 2
1 G3 1
9 1 1


thanks
Mike

[Rich P]

Re: Multiple level Bill of Material Explosion - Help please

Hi Mike,

You need to show a sample of source data and Query Result data -- like

tbl1
fld1 fld2 fld3 fld4 ... fldn

tbl2
fld5 fld6 fld7 fld8 ... fldn

tbl3
fld9 fld10 fld11 fld12 ... fldn

...

and then show a sample of what the data would look like after running
through your query

Query Result

fld1 fld2 fld9 fld7 fld20 fld30 fld17

Then someone could advise you if your table data is a relational form
that would be suitable for querying - and how to write a query (or
queries) to perform your desired operation.


Rich

*** Sent via Developersdex http://www.developersdex.com ***