Hi, I have simple BOM table with Component Item # & Parent Item # columns. What I would like to achieve is to add two columns: one with highest level item # for each component and second one with relative level in the BOM hierarchy. Any ideas how to approach this?
Of course I only listed one BOM example, but the list of finished items can go from A, B, C, up to Z.
