S
steve downs
I am attempting to create a multi-level bill of material
for parts made from sub-assemblies made of other parts,
which may also be made from sub-assemblies. Each part's
inventory record includes a reference to its bill of
material (BOM). I am currently running a query that
creates a table with all of the detail part numbers for a
part that has a bill of material. Running the query again
identifies which of the newly gathered parts have bills of
material and appends that detail to the table. I want to
run this query repeatedly until it returns no records. Is
this code that is available as a condition setting in a
Macro? What is the proper approach for this kind of
iterative query?
for parts made from sub-assemblies made of other parts,
which may also be made from sub-assemblies. Each part's
inventory record includes a reference to its bill of
material (BOM). I am currently running a query that
creates a table with all of the detail part numbers for a
part that has a bill of material. Running the query again
identifies which of the newly gathered parts have bills of
material and appends that detail to the table. I want to
run this query repeatedly until it returns no records. Is
this code that is available as a condition setting in a
Macro? What is the proper approach for this kind of
iterative query?