Re: Multi-Level BOM (Bill of Materials)

Hi,

I think a little more information is needed...

What's the linkage between [Part Number] and [Component Part Number]? ie: how would I
know which Component Part goes with which Part? There must be something in the table
that indicates this.

Are "part levels" indicated in the table? If so, how?

Any other pertinent fields we should know about?

> but the output is not what I'm looking for.
So what *are* you getting? And, what does the query look like?


John


----------------------------

"Meredith" wrote
> 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):
[...]



.

Relevant Pages

  • Re: Multi-Level BOM (Bill of Materials)
    ... > Thanks for your response MG =) I have tried this example as well, ... I will try show you how I see it in my head (I hope the ... > formatting stays): ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Format on New Database Query
    ... Thanks for the response. ... properties window doesn't mention anything about formulas. ... think of formatting, I think of font color, etc... ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: New to MCP
    ... >> As for Bob's response, there's something not right in the head there, so ... > Even fat girls have feelings. ... Prev by Date: ...
    (microsoft.public.cert.exam.mcse)
  • Re: ASP.Net Running total of Character Count on input
    ... Thanks for the response. ... I tried to place the script in the head section of the Default.aspx ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Are higher-voiced singers nuttier?
    ... > interesting response ... The one on what passes for your head? ... Goody. ... Prev by Date: ...
    (rec.music.opera)