I have 2 tables:
Tbl_Recipes : recipes_ID, recipes_title, recipes_catID, recipes_proc
Tbl_Recipes_Cats : catID, cat_desc
There is a relationship b/w Tbl_Recipes.recipes_catID and Tbl_recipes_cats.catID
I want to set a trigger that will execute when a record in Tbl_recipes is DELETED.
The trigger will delete the corresponding CatID record from Tbl_Recipes_Cats if there are no more records referenceing the deleted catID.