Originally Posted by
Ajax
difficult to answer without knowing your db design - but look at your table relationships to a) enforce referential integrity and b) cascade delete related records.
Also, by way of note, it is generally advised not to delete data, but to have a flag to indicate the record should be ignored which can then be used as criteria in queries to ignore them. There are a number of benefits - you can still 'undelete' it if it was flagged in error and you maintain a proper history - perhaps the person concerned has been with you for three years, deleting them would affect the view of the previous years.