CREATE TRIGGER trgtblBag_data ON tblDelete_Inventory
WHERE work_ord_num in
No, it still doesn't work.
How does trigger works? When an action occurred such as insert a record in tblDelete_Inventory doesn't the trigger script executes?
No syntax or any kind of error occurred.
Also, why can't I see the name of trigger in drop down box in triggers properties?
I appreciate any suggestions or possible solution.
I need to create a trigger on tblBag_data to add new rows to tblBag_databak, but I'm getting a syntax error.
If there is more than a record inserted in tblBag_data I want to append the records in tblBag_databak.
CREATE TRIGGER trgtblBag_databak ON [tblBag_data]
If @@trancount > 0