Cascading deletes are due to a setting in Manage | Database | Relationships.
Your delete all records step is deleting records from the Event Days table, so check each relationship that links to an occurrence of Event Days to see which ones specify the "Delete" option for Event Days. (Double click the relationship lines.)
yes. in the relationship between events and event days, i have "delete related records in this table when a record is deleted in other table" checked so that when an event is deleted, it will remove the event days display in the calendar display. is it possible that its working the other way even tho i do not have that option checked on the "event" side of the relationship?
No that should not be possible. That's why there are two check boxes for the delete option in the dialog--one for deletes in each "direction".
But out of control cascading deletes can be tricky to track down if you have a lot of different occurrences of the same table. You might just have this option selected somewhere else in your relationship graph and there might even be a "chain" of such options where deleting a record in table 1 deletes records in table 2 triggering a delete of records in table 3... (and each "link" in that chain of deletes could be scattered around in in different parts of your relationship graph)