AnsweredAssumed Answered

Number field is not allowing FINDS nor IMPORT MATCHES

Question asked by Cal on Aug 31, 2011
Latest reply on Aug 31, 2011 by chads.

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

Outcomes