Records disappearing unexpectedly, intermittent problem.
Operating system version
Description of the issue
Occasional intermittent problem with records disappearing permanently, and taking related records with them.
FMS11 on Windows 7 Professional
Clients on Macs and PC's running FMP11
Steps to reproduce the problem
Operator generates a new record in table 1, or uses an existing record in table 1.
Operator Creates a record in a join table (2) to relate the record to one in a third table (3).
Operator goes to a table 3 layout to see the related record from table 1 in a portal,
The record is not in the portal. Search in table 1 reveals no trace of the record. Search for records in the join table (2) also no sign of any JT records.
Exact text of any error message(s) that appear
No error messages or indications that anything went wrong.
Using the recover command on a copy of the file gives a result that the database is not damaged.
The relationship is set to automatically delete records in table 2 (the join table) when deleting a record in table 1. Not vice-versa.
A version of the same database in a similar server environment (copied two years ago) appears to be experiencing the same problem, although neither had this problem ever before.
Seems to occur only once in about every 500 times.