Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Rename one Kred.-Nr.
hope this helps
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.
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.
Rename one Kred.-Nr.
this would solve your pupose
if any concern let me know
hope this helps
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
Dear Celambarasan
Thanks for your help, this works.
Best regards
Joerg