How do I create an Exploded Parts List in Access?

[D.K. Mott]

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!

 

[KARL DEWEY]

Build tables in layers and set relations.
TopLevel--
ItemID - autonumber - primary key
Item - text - model number
Description - text or memo base on how much you need - start with text and
255 characters.
Price - currency

Assembly--
AssemblyID - autonumber - primary key
ItemID - number - integer - foreign key
Item - text - model number
Description - text or memo base on how much you need - start with text and
255 characters.
Price - currency

Parts--
PartID - autonumber - primary key
AssemblyID - number - integer - foreign key
Item - text - part number
Description - text or memo base on how much you need - start with text and
255 characters.
Price - currency

Use subforms. You can have three layers with the third layer as a datasheet
view.

 

[Pat Hartman\(MVP\)]

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.