Re: How do I create an Exploded Parts List in Access?
- From: "Pat Hartman\(MVP\)" <patsky@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 10 Nov 2005 00:17:50 -0500
If you know how deep the BOM is, you can create a query that includes the
part table as many times as there are levels. You draw join lines from the
parent id of one instance to the child id of the next instance to connect
the tables.
If you don't know how deep the BOM is, you need to write a recursive code
routine to walk the tree. I don't have any code samples but you should be
able to find one if you search.
"D.K. Mott" <D.K. Mott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F5F2E6E6-2F24-4905-9BDA-3DB6FA3B614B@xxxxxxxxxxxxxxxx
>I have created a Query and Report in Microsoft Access fir a "Single Level
> Parts List" but with my limited knowledge, I have yet to find a way to
> make a
> "Top Level" Parts List to have it shown "Exploded". Meaning to be able to
> see everything that reports to the Top Level and what each of those items
> directly report to to get to the Top Level. I'm not sure if I'm amking
> sense
> at this point!
.
- Prev by Date: Re: Access Front-End with Sql Backend Tables
- Next by Date: Re: Inbound and Outbound relationship logic
- Previous by thread: Access Front-End with Sql Backend Tables
- Next by thread: Re: Inbound and Outbound relationship logic
- Index(es):
Relevant Pages
|
