BoM and corresponding Data

[Oguzhan]

Hello,

I have a BoM Table like the following  bellow. I want to Load the table and in the next Step I want to Filter for e.g Field "Component Description" and LookUp Product A11x9 and get the Information about the Subcomponent/SubDocument/Submaterial/Subdrawing. My Problem is that the Documents belonging to the Installed Part have no Level assigned.  I am happy about every help

Best Regards

Oguzhan

RowNo	Level	Head of Partlist	Description	Component	Component Description
1	0	1713	Product A11x9	1713	Product A11x9
2				8862	Subcomponent A
3				5094	Subdocument A
4				4867	SubDrawing A
5	.1	1713	Product A11x9	2876	SubProduct A
6				2377	Subdrawing B
7	..2	2876	SubProduct A	1173	SubProduct B
8				1743	SubMaterial B
9	...3	1173	SubProduct B	5533	SubDocument C

[stevejoyce]

How do you determine what Product a Subcomponent belong to?

[Oguzhan]

Thats my problem unfortunately. In my Excel list, its clear because its chronological that mean everything without a level belongs to the Component. E.g. 1713 is my Product Number and (8862 Subcomponent A, 5094 Subcomponent A and 4867 SubDrawing A ) belongs to that product until in Level .1 that Product gets split into another Subproduct with its own documents . This hiararchy goes up to ........12 or even further.

My idea was to create 2 Tables:  In the first table I load all the Materials, and in the second table all of the Drawings and Documents and Link them with the material ID of the Products which is Unique. But that didnt worked as expected.