table/database question

  • Thread starter Thread starter CCD
  • Start date Start date
C

CCD

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?
 
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?
Click to expand...

Joe Celko's BOM

http://www.mvps.org/access/queries/qry0023.htm
 
Back
Top