AnsweredAssumed Answered

"Store" calculation result of a match field?

Question asked by ezeitgeist on Nov 4, 2016
Latest reply on Nov 4, 2016 by 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.

Outcomes