I inherited a FM application and it was working fine.  Now when I open it, a form is displayed and initially 30 records appear and then immediately the records count drops to 7 before any action is taken.  The data is in mySQL.  If I watch a trace on the database I see an initial query "select * from invoice", and then quickly a second query "select * from invoice where year = 2012"  which limits the results.  

 

I opened a FM support ticket and was instructed to  uninstall and reinstall FMP.  I've done this multiple times.  I also attempted to delete all FMP files in "Library" with input from support.  

First Uninstall FileMaker then go to the user Library: Finder> Go > (Hold Option) Library

Locations:

-Application Support will have a FileMaker Folder you can trash

-Caches will have some com.filemaker... folders as well as a FileMaker folder

-Preferences will have some com.filemaker... plists

-Saved Application State will have come com.filemaker... folders

 

This does not happen on another developers laptop with the same .FMP file.   

I rebuilt a 2nd laptop and I get the same missing data behavior with the FMP file that works on the other developers laptop.  And was previously working on mine.  

 

Any help would be greatly appreciated.  

Edited April 23, 201510 yr by pdxpro

What happens when you show all records?