bill of materials query

  • Thread starter Thread starter locochon2010
  • Start date Start date
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
 
I don't think you have supplied enough information. Please check your
originial, and add info as needed.
 
Back
Top