How to connect 2 tables

[omyahamburg]

Hello all

I need to connect 2 tables, but my problem is that I don't know how to create this key, as

only 1 parameter is found in both tables, the second parameter is coming out of a third table.

The situation causes a circular reference as shown in attached picture.

Does anybody know how I can avoid this ? I have (as a beginner) no idea at all how I could create

a usefull key with these 3 tables..

Thanks for your help.

best regards

Joerg

[SunilChauhan]

Rename one Kred.-Nr.

hope this helps

[omyahamburg]

Dear Sunil

I did not explain good enough.

I need a key with "EINECS"+"Kred.-Nr." from table 1 to table 3.

The problem is that I only get the "EINECS" for the "Item No_" in table 3

out of table 2.

Thank you.

[omyahamburg]

Dear Sunil

I did not explain good enough.

I need a key with "EINECS"+"Kred.-Nr." from table 1 to table 3.

The problem is that I only get the "EINECS" for the "Item No_" in table 3

out of table 2.

Thank you.

[SunilChauhan]

Rename one Kred.-Nr.

this would solve your pupose

if any concern let me know

hope this helps

[CELAMBARASAN]

Hi,

     Join any one table with the other one and make unique key between the joined table and the table 3.

     Like join Products All DataS and Item by EINECS and delete the Item table.

      Make a unique by joining Kred.-Nr with ItemNo in both the table.

Hope this helps.

Celambarasan

[omyahamburg]

Dear Celambarasan

Thanks for your help, this works.

Best regards

Joerg