Need your suggestions..
The below is the issue:
I have fields with values:
Field_A I Field_B
100 I P
100 I Q
100 I R
200 I X
200 I Y
200 I Z
If in Field_A I select the value 100 , for Field_B .. i shud have the option to select only P or Q or R .
Similarly, in Field_A if I select the value 200 , for Field_B .. i shud have the option to select only X or Y or Z .
I have already tried the below:
1. i have tried it with Nested lookup. The reason it does not work in this case is, we see it as a combination. For ex:
2. If i am using Field_A as Non-Qualifier and Field_B as Qualifier and imported the data. So, next time i create a record, selecting Field_A as 100 , in Field_B .. all the values are displayed.. i.e P,Q,R,X,Y,Z ... whereas we want only P, Q, R to be displayed.