Does BOM have links to which drawings are using the parts in it?

[aerostudent2618]

I trying to understand if BOM can be linked to its parts and if the parts can be linked to which drawing is using it.

If this is possible then i can put this into excel and use some macros to sort the data such that it will show eg: part 1 located in ---- DRAWING SHEET: 12, 14, 20 etc. I need to do this for many parts

I jus need to know if BOM can link to Parts, Parts can link to Drawing sheet.would really appreciate ur opinion/solution/idea