dependent help

[Pramod5]

We have created 2 fields both are reference field.

Parent (L1)

Name (l2)

Now The Requirement is 

L2 Commodity code depends on L1. If you choose any L1 on the children of that L1 should be available to choose in the L2 reference field. 

We have excel too

Suppose if we are selecting from L1  Advertising & Marketing so From L2 field only below option should be available  to chose .

I have written reference Qualifier but looks like it doesn't work. 

javascript: 'u_parent!=NULL^u_parent.u_name='+current.variables.ariba_commodity_code_l1.getDisplayValue();

How do i achieve this ...Please help me on the same 

Many thanks 

[Shruti Khaire]

Hello @Pramod5,

Can you elaborate the functionality you are trying to achieve which table have you passed to those reference fields. Is it sys_choice? or something else. Also is it necessary for those fields to be reference fields? since I have worked on similar scenario where in we kept the field type as choice and list collector which makes it even more easy. Do let me know so that I can help further.

Thank you!

[Pramod5]

Both are referencing the same table( Custom table) which has got 3 fields