Title
Missing Records in Database
Post
When attempting to locate specific files (in the form of subject information) using the "find" icon, some claim to not exist, producing a non-existence notice. However, after reviewing our files, it is clear that we have indeed entered the information at some point in the past. Is there a reason for this, and if so how does one go about rectifying the issue?
Thank you,
Josh
There are numerous possible issues from what users have done, to how your database is designed to possible damage that may have occurred to the file itself and perhaps something wasn't quite right with your search criteria.
Here's an incomplete list of why data might seem to "go missing":
1) The data has been modified to the point that it either no longer resembles the original version or is not being "found" by your search criteria.
2) A user deleted the record
3) A script deleted the record.
4) due to a "Delete" relationship option being selected, either 2) or 3) above deleted a record in a related table and a "cascading delete" deleted this record as well.
5) There are many ways that a particular interface design might "hide" records with specific values from view. Thus the record(s) may still be there, but not be accessible from the current layout or when the file is open with a specific privilege set.
6) A damaged field index can keep FileMaker from finding or sorting records correctly. You can use Advanced Recover options to rebuild all indexes in your file. (use the copy file blocks "as is" and Rebuild index options).