Hello. We are using logic in our field to display it. Something like this:
If(IsNull(Qty) = 0 AND (Qty <> 0.0 OR MktValue <> 0.0),
if(IsNull(ForwardInvCode) = 0, ForwardInvCode, Investment)
We are able to get the Investment Codes display just fine like this and fit our needs.
But when we try to search, we run into the issue described in OP.
Could using formulas and logic be a limitation? As well, we have many thousand distinct Investment codes.