AnsweredAssumed Answered

Stored Calculation with Related Fields

Question asked by alas on Oct 1, 2012
Latest reply on Oct 1, 2012 by comment

I have two tables. One has a Producer name. The other has a Brand name. The Brand names are related to their corresponding Producer name by a unique key for the Producer.

 

I then have a calculation field in the Brand table that does Producer & " > " & Brand, so I end up seeing: Producer > Brand as the display name.


But since this is pulling the Producer name from a related table, I cannot store the calculated result. And therefore I cannot index it, which makes for extremely slow finds, especially since I have over 45k records.

 

How do I work around this to enable me to create a stored calculation result that can be indexed? Or what alternative is there for creating something more efficient for finds?

Outcomes