I created a trigger on tblDelete. Aftering inserting a record in tblDelete it will delete the same record in the tblInventory.
The problems are the trigger doesn't execute. The record(s) are inserted onto tblDelete but it doesn't remove in the tblInventory. When I go in the trigger properties under name drop box the trigger I created is not there. But when I tried to create a new trigger it saids the trigger object is already exist in the database.