Records being deleted
We have a student database where we have two external sources tied into this database. Once in a while we have a student record that gets deleted from the student database. Is there a possibility that a record/s can be affected on the student database if a change or deletion is done on any of the two external databases. One external database links faculty information into the student database and the other external database links district information into the student database.
Are these external databases FileMaker Pro Files?
Do they have relational links to the file where the records are disappearing?
Do one or more of those relationships have "delete related records in this table when a record is deleted in the other table" enabled for the table where you have missing records?