14 Replies Latest reply on Sep 30, 2016 2:02 AM by Johan Hedman

    Text Field - Strange behavior


      Hi all


      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. :/