bill of materials query

L

locochon2010

Hello, I am using Access2003. I need a recursive query that will explode an
assembly into all its basic raw materials components (no sub-assemblies must
be listed) with quantities - from a bill of materials table. Our bill of
materials have at least 5 levels, and it is possible that one raw material
can be used in two or more subassemblies (I am not sure this last statement
is relevant). In the end, I should have something like this:
PARENT - CHILD - QTY

This is the starting information:
TABLENAME: tblBOM
Fields:
Assembly
Component
Qty
 
S

S.Clark

I don't think you have supplied enough information. Please check your
originial, and add info as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing XML bill of materials 4
Bill of Materials 2
Access 2000 Recursive Query Help 2
Parts List/Bill of Materials 2
Bill of Material Query & Report 3
Iterative Query 1
Creating a Bill of Materials Query 3
Return ID of Lowest Cost 2

Top