The only thing I could think of that could cause this would either be A) a scripted loop Or B) improperly defined cascading deletes
I've attached a picture of the script, but i dont have a loop, or cascading deltetes.
You're right, there's definitely no loop present there... and even if there were one outside of what I can see of the script here (or a calling script for instance), then you would know about it because you would get a custom dialog for each record that it's about to delete.
As far as the cascading delete idea is concerned though, how complex is your relationship graph?
What I usually recommend for hunting down possible cascading deletes is that you select a table occurrence based on the table that is getting all its records deleted (on the relationship graph). Once selected, you can pick the option to select tables with same source. This will highlight all of its peers. Investigate every relationship to every one of those highlighted table occurrences, and check for "Delete related records in this table when a record is deleted in the other table". Make note of any that have that checkmark, and confirm that it's configured properly.
Hopefully this proves helpful
That did the trick. Thanks man
That's great news.
I guess you can call me Glad too.