making dependent

[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 .

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

Many thanks 

[Harsh_Deep]

Hello @Pramod5 

Please share snip of your fields on form and whats the reference field table name and whats the relationship between both references

[Pramod5]

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

[Harsh_Deep]

Share the dictionary level of that custom table