Help with Audit Trail

[Gannet]

I'm developing an audit trail using some code and ideas from ghudson's audit trail. I'm having all changes, new records, and deletes saved in a table. The issue I'm running into is capturing deleted field in my tables that have relationships with parent tables. I have included a sample database that has two tables of data. The form "frmCategories" has a delete button to delete the parent record. This will also delete the related records in table "grades" but I need a way to capture the fact that these records were deleted.

 

[gemma-the-husky]

if you delete a record, its normally because it should never have been there, and you probably wont have a home to store the deletion information

if it shouldnt be there, but you want to keep the record, then flag it as notused etc instead,- then you will have a home for a audit trail entry