2 Replies Latest reply on Nov 4, 2016 1:18 PM by ezeitgeist

    "Store" calculation result of a match field?

    ezeitgeist

      I have a table that stores company information. I have a linked table of contacts that are linked via the company_ID.

       

      To list the name of the company in the Contacts table, I have a calculation that just equals the company name in the related Company table. I have to do this because I am using MasterDetail and want to list the company name in the side panel that has Contact Name, Company, Region, and Field of Expertise.

       

      To make the MasterDetail load faster, I tried to index/store the calculated field results, but it would not let me. I am assuming because the result could change (periodically). Is there some way to force a store and then check periodically automatically? Or, a better way of getting the field to match? I have the tables setup like this so if an employee changes companies, it is just an easy ID change.