Search all selected value in two fields and display the resultant value

[varunreddy]

Hi All,

I am having two tables Customers and Relations.

• I have Cust_Id in customer table.

IP_ID_Num

100

200

300

• I have Cust_Id and Relation ID in Relations table.

IP_ID_Num	PRSL
100	200
100	300
200	400
300	200

Association between these two tables is IP_ID_Num.

When we select 200 from IP_ID_NUM, I get to see 400 from PRSL.

But my requirement is when we select a value from IP_ID_NUM, I need to search for that value in both IP_ID_NUM and PRSL fields.

When I select 200 from  IP_ID_NUM, I need to see two rows.

1. IP_ID_NUM - 100 and PRSL - 200. (Because PRSL value is 200)

2. P_ID_NUM - 200 and PRSL - 400. (IP_ID_Num value is 200).

Can anyone please help me?

Thanks in advance!

[Digvijay_Singh]

Hi,

As you mentioned -

When I select 200 from  IP_ID_NUM, I need to see two rows.

1. IP_ID_NUM - 100 and PRSL - 200. (Because PRSL value is 200)

2. P_ID_NUM - 200 and PRSL - 400. (IP_ID_Num value is 200).

I feel it should select

3. P_ID_NUM - 300 and PRSL - 200. (Because PRSL value is 200).

[Digvijay_Singh]

See if this can help. I needed ID field in Relation table -

[varunreddy]

Hi Digvijay,

Sorry, it should select 3 values. I need to see all the values of IP_ID_NUM where IP_ID_NUM or PRSL is 200.

1. IP_ID_NUM - 100 and PRSL - 200. (Because PRSL value is 200)

2. IP_ID_NUM - 200 and PRSL - 400. (IP_ID_Num value is 200).

3. IP_ID_NUM - 300 and PRSL - 200. (Because PRSL value is 200).

Is there a way to achieve?

[varunreddy]

Did you try to attach any solution ?

[Digvijay_Singh]

Ya, I can see it attached? Are you not able to see QVW attached?

[varunreddy]

No I cannot.  Can you please attach again?

[Digvijay_Singh]

Attaching qvw once again.

[Digvijay_Singh]

Now? I needed one extra ID field in relation table as Customer Id is repeating in relation table.

[varunreddy]

I don't see it. Can you please explain me how you did it?