Did the Recover Log show anything ?
Records dissappear when the index is corrupt, or the internal record ID's get scrambled
I saw it quite often in FileMaker 9, but not in 11, and not yet in 13
It is always possible, that you found a new iOS bug
I've complained to FileMaker in the past, but they can't fix this, unless it is repeatable. See if you can make it happen
Data separation might help, but corruption in any one file can disrupt the whole solution anyway. Perhaps a new table, in the same file ?
> A few months ago, they upgraded to Server 13 and all the workstations are also upgraded.
Now since then, the problem seems to have reared it's ugly head again, this time, with "blank" records- no values in ANY of the fields at all. If you search for a particular record ID, it will show in the found records results, but there is just nothing in the record.
Now, there are iOS devices connected via WAN, as well as desktops and it would seem that the records that are dissapearing are ones entered on the iOS device.
I've done the usual things, compressing the file, recovering the file, even exporting the data and re-importing after doing the save as clone, compressing the clone etc...
What does the data look like after exporting to another file? I'd try FMP, but XLS might yield different results. What about exporting and then if the data is clean, deleting all records and importing?
Exporting the records as .mer then importing them again cleans the data. The only issue is, the original corruption comes back after a period of time... does not matter any more, my client has decided to move away from filemaker
I'm sorry to hear that. If you wanted to give it a shot, export all tables, save a clone of the db, open and save that file as compacted, then open that copy and reload all tables. Again, sorry that they didn't stay with you.