Number field is not allowing FINDS nor IMPORT MATCHES
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.
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
no records found
Sounds like you might have a bad index. In the field option, set indexing off, save and close, then turn it back on and see if the issue is still occuring.