Making a "Used On" column in BOM

[Splinterb1]

Hello.


I am trying to add a column to our BOM that can show what assembly that certain part is used on.


Here is what I am after












PART NO.
QTY
DESCRIPTION
MATERIAL
USED ON

ASSY-A1
1




ASSY-A2
1




PART-100
3
ETC

 

[s_pme20]

what is your question????

 

[Splinterb1]

I am trying to add a column to our BOM that can show what assembly that certain part is "used on". The BOM I have shown is just something I did real quick in excel to show what it is I am trying to accompllish.