Delete Records using Multiple Conditions

Delete Records using Multiple Conditions

Hello,
I have "Kids" form where i have design no, shade no and multiple sizes say 28, 30, 32, 34 and so on and they are updated when delivery challan is created.
Now i want to delete the particular design no. when all the sizes of the particular design no is reduced to 0.