Are there local copies of some data?
A script reported a couple records with required fields empty. A manual Find didn't find any. A little more looking and I could find in a Show All view the two records with empty fields. I could sort on that field and they end up at the bottom (ascending). But still a Find wouldn't find them. (Nope, not just a space or some hidden text.) This is a hosted file. The server ran a consistency check the night before and it was fine. Finally I quit my local copy of FM altogether, reopened FM and the file, and then those records had the correct data in those fields. Huh?
Client is FM Pro Advanced 13.
Server is FileMaker Server 13
File is opened remotely across the LAN.