I have got a strange behavior on one of my fields. One of my users pointed out to me that one of my fields was not searcheble (not 100% sure it ever was).
Text field is named "CostCenter" and is a text field, but most of the times there is only stored numbers. (dont think that matters since i dont use them as numbers).
Table are "Personal reg" and just store all workers (still working and them who left) and information about them.
If i search the field CostCenter for "*" i get all targets that is not empty and if i search "*" omitted i get all empty fields. that works fine.
But if i search a specific CostCenter that i know exists, i get the number of records there is, but all fields are empty even that its not, sometimes they show as "?" on all fields.
Example 1: (how they look)
Example 2: (after search done for the CostCenter 7000060)
If i search any of the other fields its fine, all shown as normal. And inside my other tables where i use this information its not searchable ether.
The field CostCenter is really basic, no calculations or anything.
Do anyone have any idee why this is ? its problebly something really easy, but i cant figure out what. :/