Nested bill of materials

[Guest]

How do I create a nested bill of materials (BOM) in Access where existing
parts numbers can be used on other BOM's also?

 

[Rick B]

I don't think anyone will be able to answer this. You are asking in your
industry terms, we need to know in database terms. How is your data
structured? What are the realtionships between the tables? If this is a
parent/child report issue, we would need to know how the report and
subreport are structured and related to each other.

Post back and pretend we are computer geeks that don't work in your industry
and have no idea what a BOM is.

Rick B

 

[Immanuel Sibero]

Have you checked out the following?:


http://www.mvps.org/access/queries/qry0023.htm
http://www.mvps.org/access/modules/mdl0027.htm

Immanuel Sibero

 

[Douglas J. Steele]

Rick: BOM is pretty standard terminology. As Immanuel pointed out, there are
a couple of references to it at "The Access Web"