Index a Referenced Field
I have 2 related solutions. 1 solution = EE information; the other solution is my primary solution. I want to speed up searches based on the ACTIVE/INACTIVE status, but I can't index the field from the EE table because its a referenced field. Is there a work around that I can perform to get the result into the primary solution as text so that it can be indexed?