On Oct 25, 10:20*pm, CCD wrote:
this is the information i want to store in my tables. *i have an assembled
product, let's call it a car. *The car will have several different assemblies
with each assembly having different components. *Example: *Car1 has Assem1
and Assem3 --- Assem1 includes components A1, A2, A3 and A4.
what i would like to be able to do is a report for Car1 that lists all
components within the assemblies for ordering.
Is this possible?
Joe Celko's BOM
http://www.mvps.org/access/queries/qry0023.htm