Hi there - thank you for your comments and help in advance.
My setting: I have 2 tables in one base, containing product information.
My goal: to enrich one table (main-table) with the details of the other table (detail-table).
context: The main table contains the product name (e.g. Solvent black 27). The detail table contains that name as well (Solvent black 27) - but additional details, like e.g. color index.
How can I enrich the data in the main-table with further details of the detail-table.
I tried to do a lookup, of course, but the I dont find a way how I can ensure, that the lookup field always has the same name as the name of the main-table.
To make it more understandable: In SQL I would be a "clasical" join.
Thank you for your support