Point taken Greg.

Here is an Excel Spreadsheet extract from the BOM Table.

Fields:

Field1 = Parent Stock Code

Field2 = Line Type:

P = Part

M = Manufactured Item

D = Description Only Item

Field3 = Child Stock Code

Field4 = Duplicate of Field3 (just the way it extracts from the system)

Field5 = BOM Quantity

Field6 = Description

The primary objective is to simply display "S/A of PCB" items to the user so that they can plan PCB manufacture in advance. So, using the attached BOM.xls file, let's say the user wants to find out ALL S/A of PCB items that are used on a TX5922.AA Stock Item.

I need an input for the user that allows them to enter the required stock item and a build quantity. Then all I need is for the results to be displayed on the screen so that it can be printed ready for PCB manufacture.

So, as per my previous post, I would enter the Stock Code TX5922.AA and I would get the following results:

P5430.06 S/A of PCB (which is in this level of the BOM)

P5431.06 S/A of PCB (which is in this level of the BOM)

However, there is another S/A of PCB within this build but it is in a different S/A at a lower level. The result should be:

P5430.06 S/A of PCB (which is in this level of the BOM)

P5431.06 S/A of PCB (which is in this level of the BOM)

P5431.94 S/A of PCB (which is in a sub-level of the BOM - being P5431.09.01)

I am stuggling to get the correct results. Some of the BOMs have many more levels than this example, this is just a simple BOM.

Thanks in advance for any help.

Andy.:)