Lookup fonction in calculation field on a set of a table
I have two related tables, Products (fields: id of the product and lot of technical characteristics) and Synonyms (3 fields: id of the product, company, "name given to the product by that company").
I want to add a calculation field in the Products table looking up in a particular set of Synonyms table, i.e. for the name given to the product by a specific company.
what should I do?
thank you for your help