selection issue

vipin_mishra479 — Fri, 15 Jun 2012 04:38:38 GMT

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

Re: selection issue

deepakk — Fri, 15 Jun 2012 04:48:01 GMT

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