1 Reply Latest reply on Aug 31, 2011 1:55 PM by chads.

    Number field is not allowing FINDS nor IMPORT MATCHES

    Cal

      Summary

      Number field is not allowing FINDS nor IMPORT MATCHES

      Product

      FileMaker Pro

      Version

      8.5

      Operating system version

      Windows 7

      Description of the issue

      Recently a number field used for matching new data with old data began acting strangely. I can copy the contents; "1234" for example, enter FIND mode, paste the contents and FMP will not FIND the record! This also prevents it from matching properly when used as the macth field. I tried changing the field to text then back to number and it worked once. It ehn reverted back to not working.

      Steps to reproduce the problem

      1. copy number from feild
      2. enter find mode
      3. past or type number into same field
      4. perform find
      5. no records found result

      Expected result

      record found

      Actual result

      no records found