Watch out for RI when youre dealing with buffered tables, it has happend to me that if I delete the parent record in a buffered table and the delete RI is supposed not to let delete the parent, it can be deleted anyway.