Re: Multi-Level BOM (Bill of Materials)

Thanks for your response MG =) I have tried this example as well, but the
output is not what I'm looking for. What I need is an all inclusive, simple
list of part numbers from all part levels including and below the highest
level part. I will try show you how I see it in my head (I hope the
formatting stays):

Level Part Number
1 ABCD <--Parent
2 1234 <---Child
2 5678 <--Parent (9012 and 3456) and Child (5678)
3 9012
3 3456
1 ZYXW
2 9876
3 5432
3 1987
4 AB12

What I need is a list that will give me all of the part numbers, regardless
of level in one single list.

Parts
ABCD
1234
5678
9012
3456
ZYXW
9876
5432
1987
AB12

This seems so simple in my head but for the life of me, I can't figure it out.

I do appreciate any help you can offer.

Mer

"MGFoster" wrote:

> Meredith wrote:
> > 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
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
.

Relevant Pages

  • Re: Deleting a table in the backend using VBA
    ... subcomponent of a BOM as it drills down into the BOM. ... set of data (append query). ... I am trying to delete a table in the backend database using code in the ... frontend, for querys used in the frontend afterwards. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Recursive BOM
    ... Thanks, I explored the nested sets solution, I found all the info ... The problem is the standard BOM problem. ... Here's a 3 levels exemple: ... I'm trying to have a query that would give me for a given part, ...
    (comp.databases.ms-access)
  • Re: How do I create an Exploded Parts List in Access?
    ... If you know how deep the BOM is, you can create a query that includes the ... >I have created a Query and Report in Microsoft Access fir a "Single Level ...
    (microsoft.public.access.tablesdbdesign)
  • Start With/Connect By problem
    ... I'm trying to help a colleague with an SQL problem; ... item in a Bill Of Materials (BOM) - and Start With/ Connect By seems to be ... Contract 'EMGA'. ... the query then only shows BOM entries for the top level. ...
    (comp.databases.oracle.server)
  • Recursive BOM
    ... The problem is the standard BOM problem. ... tblBOM: ... Here's a 3 levels exemple: ... I'm trying to have a query that would give me for a given part, ...
    (comp.databases.ms-access)