Skip to Content
0
Former Member
Feb 18, 2010 at 07:26 AM

Create record with 1:N relationship based on condition

16 Views

Hi SDNers,

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:

100;P

100;Q etc..

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.

Please suggest.

Thanks,

Priti