Skip to Content
0
Former Member
Nov 18, 2004 at 11:30 PM

Help on Query!!!

25 Views

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.