table/database question

[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?

 

[Gmail]

Are you talking about displaying the results in XML format or something
else?

ro

 

[CCD]

any format (access standard if it has one)

Are you talking about displaying the results in XML format or something
else?

ro

 

[Monkey Butler]

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