5 Replies Latest reply on May 27, 2010 2:53 AM by comment_1

    Lookup fonction in calculation field on a set of a table

    pitagora

      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