selection issue

[vipin_mishra479]

hi i have a 3 field

order, material , and level

326001 is my order and 1224 is my material for respect to that i have two level 04.02.01 and 04.02.02 which is text formate

eg.  order          material      level

       326001      1224           04.02.01 , 04.02.02

       326112       3251          06.01.00

       326521       2215          05.02.03

and my question is that

when i select   this 326001 order and   this material 1224  then how to i get only 04.02.02  level

[deepakk]

Hi vipin,

Create another field as below

subfield(level,',',1) as level1,

subfield(level,',',2) as level2

So when you select 326001 and 1224 u will get 04.02.02 in level1

Deepak