maybee it is either a random order by unsorted date ( you think you see the third record from top, but the third record is another as before refreshing)
or you should try the refresh window script step with both options set.
greetings from germany
I have the same problem. Please let me know if you find a solution.
The problem appears to happen when I connect to a MySQL source, and then that data is edited in another application (non-Filemaker). This then 'hides' it in Filemaker, such that it appears to have disappeared (the record count decreases). I can find them individually by searching for specific criteria I know exist in the record, but that only brings it up temporarily, and it disappears if I do other stuff.
I noticed in list-view, if I refresh, it momentarily shows all the records with question marks in them, and then most of them disappear from view. Performing a find does not bring all of them back, neither does refreshing the window.
Hope someone can help!