Either you are deleting a found set of two records or you have a relationship with the "delete" option specified that deletes related records when you delete the current record.
This would appear to be a "self join" where you have two occurrences of the same table linked in a relationship. Please note that any table occurrence based on this table in the file might be the culprit.
I definitely don't have more than one record selected when I delete. I do however have multiple occurrences. Is there a way to "self-unjoin"? :)
Or maybe I just need to create a script that defines variables from field values, and inserts them into a new record rather than duplicating? That just seems like too much maintenance when/if I add/modify fields...
Thanks for the help.
You need to find the relationship with the delete option that is responsible for this.
Once you have found that, you can look at what options can be taken to correct the issue. It might be as simple as clearing a check box in the relationship options dialog that enables this delete or your script might need to clear the value in a match field to "break" the connection between the two records.
But you have to find the relationship responsible first.