By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 733 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Multiple level Bill of Material Explosion - Help please

P: n/a
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

ParentItemNumber ChildItemNumber QuantityPer
-------------------------- ------------------------
-------------------

1 G1 1

1 G2 2
1 G3 1
9 1 1
thanks
Mike

Oct 30 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 ***
Oct 30 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.