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?