"Robert Bravery" wrote:

> HI all,
>
> I need help on some SQL logic.
> I have a two tables related. The parent has cascading deletes set. Which
> obviously means when deleting a parent all children are deleted as well.
> Which is what I want.
> Also the user has opertuninty to delete indivisual child records, With one
> exceptions. He cannot delete the child record if the is only one record
> left. He either has to leave it as it it, or add a second child then delete
> his original choice, or delete the child along with the parent.
> I had put in a delete trigger to do this, but because my logic is flawed,
> when, correctly deleting the parent, the delete fails because my trigger
> wont allow the child record, being the last one to be deleted.
> Does anyone have any ideas as to how I can achieve this buisness rule
>
> THanks
> Robert
>
>