Hello all,

I am hoping someone can point me in the right direction (previous asked and answered question or video out there somewhere) about the following issue...

I have a single table in a db called "Materials".
This db lists all the part numbers (PartNo) in our shop that are not purchased outright as finished goods (i.e. assemblies, raw material...)

For example, Part "ABC" may be shown in the table as...

PartNo	SubPartNo	Desc
ABC	123	Plate
ABC	456	Handle
ABC	789	Bolt
123	ZYX	Washer

"ABC" will be listed in the PartNo column for each SubPartNo that belongs to it. The Desc column is describing the SubPartNo.

The last row shows part "123" which is a sub part of "ABC" but also contains sub parts of its own (ex. "ZYX"). This could go on for several sub-levels. ("ZYX" have sub-parts, those sub-parts have sub-parts, so on and so on.)

What I want to do is create a report that will list a PartNo of my choice and then in an indented format list all the sub-parts down to the lowest level.

Hopefully I have explained this well enough. I don't want to be hand held through the process but maybe a gentle shove in the right direction.

Thanks!

Thanks!

I'll take a look at that and see if it is what I need.