AnsweredAssumed Answered

Lookup fonction in calculation field on a set of a table

Question asked by pitagora on May 27, 2010
Latest reply on May 27, 2010 by comment_1

Title

Lookup fonction in calculation field on a set of a table

Post

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

Outcomes