Help on Query!!!

Hello Everybody,

I have create a query which has search on Material.

Ex.

Item.No Material Material.No Serial.No

10.000 -

---

Higher Level Material -- Mat.100 -

---

100

10.100 -

---

Sub Level Material -- Mat.010 -

---

200

10.200 -

---

Sub Level Material -- Mat.020 -

---

300

10.300 -

---

Sub Level Material -- Mat.030 -

---

400

10.010 -

---

Sub-Sub Level Material -- Mat.0XX -

---

500

10.020 -

---

Sub-Sub Level Material -- Mat.0YY -

---

600

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.

Kris.