2 Replies Latest reply on Feb 19, 2010 5:56 PM by firth5

    "Find" problem

    firth5

      Title

      "Find" problem

      Post

      I am having confusing results in a FIND.

       

      I have a calculation field.  When I do FINDS using known results of the calculations, it will find some of the results, but not others.

       

      For example, the calculation results in one of the following:  "Reuse", "Turned In", or "Not Assigned".

      I've got a value list assigned for each of these results, to use for finds. 

       

      If I select "Reuse" it finds all the records that say "Reuse".

      If I type in "re" it does not find anything.

      if I select "Turned In" it does not find anything.

      If I select "Not Assigned" it does not find anything.

       

      What did I do wrong? (I've double checked that the calculations and the value list are both spelled the exact same way.) 

       

       

      I should mention I'm on FM 10.3, on a Mac.