bring text field from another table based on 4 ID exclusive

[jppuam]

Hello,

i've the following 2 tables.

table A, with 4 IDs that cross with other table with also with a ID field.

But what i want is to bring the App_name that exist on the 2 table.

I have an active relationship with the ID1_ID2 (table 2) and 3 more with the others IDs (2, 3 and 4) from table 1.

I want to check if table1.ID1 exist in table2.ID2, and bring App_name

if doesnt exist, check table1.ID2 with table2.ID2...and so one...

if doesnt exist, check table1.ID3 with table2.ID2...and so one...

if doesnt exist, check table1.ID4 with table2.ID2...and so one...

i've tried the treatas and the userelationship, and its not working. Can you understand why ?

thank you,

JR

[jppuam]

thanks for the attention, i've managed to create a way.

JP