Multi-Level BOM (Bill of Materials)

[Guest]

I have a dilemma with a multi-level BOM which has plagued me for months. I
use linked tables which are in a data warehouse which I have no control over
so the tables/fields cannot change. The table I'm using has the following
fields:

Part Number
Component Part Number
Quantity

I need to be able to input the highest level Part Number, and the query show
all of the parts below (which includes up to 10 levels of parts.) I am not
concerned with quantity, cost or anything along those lines. I only need the
part numbers.

In my many attempts to create this query, I always manage to loop back into
infinity and usually just give up. I have tried studying up on the Celko
Nested BOM example, but I don't think I'm going to be able to use that with
the tables I have available to me.

First of all, is this even possible? And if so, how? =)

Much thanks!
Meredith

 

[MGFoster]

I have a dilemma with a multi-level BOM which has plagued me for months. I
use linked tables which are in a data warehouse which I have no control over
so the tables/fields cannot change. The table I'm using has the following
fields:

Part Number
Component Part Number
Quantity

I need to be able to input the highest level Part Number, and the query show
all of the parts below (which includes up to 10 levels of parts.) I am not
concerned with quantity, cost or anything along those lines. I only need the
part numbers.

In my many attempts to create this query, I always manage to loop back into
infinity and usually just give up. I have tried studying up on the Celko
Nested BOM example, but I don't think I'm going to be able to use that with
the tables I have available to me.

First of all, is this even possible? And if so, how? =)

Look at this site for an example of BOM in Access:

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

 

[chuck.streb]

Look here ... http://www.mvps.org/access/queries/qry0023.htm