Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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