I have create a query which has search on Material.
Higher Level Material -- Mat.100 -
Sub Level Material -- Mat.010 -
Sub Level Material -- Mat.020 -
Sub Level Material -- Mat.030 -
Sub-Sub Level Material -- Mat.0XX -
Sub-Sub Level Material -- Mat.0YY -
So there are line items in an order, all I need is when I select a Sub-Sub Level Material and I do search for a Serial Number Range, I should be able to see all the Higher level material and their serial numbers.
Kindly suggest me some solutions, I mean all the possible ways I can do this.
Thank you for your time.