This Can't be Good

Opened up one of our tables to find that a certain range of records are now out of order and some records have been deleted. But not an intentional or user delete. Across all the fields within some records we are seeing #Deleted - has anyone ever ran into this before. Did it really delete some of the records or has it just added records that say delete. We've got our backup so we are covered but want to prevent this from happening in the future. Any thoughts?

i' ve seen "#Deleted" when between two tables connected with relationship, i deleted a record from one table and there was no related record with the other record...



the retationship settings were..

- enforce referential integrity

- cascade update related files

- cascade delete related files