I have a parent table that has a one to many child relationship with many tables. I need a cascade delete trigger with correct syntax. Keep in mind I have never written a trigger before. If you could use this example:
tables/fileds are: master.MID, link1.L1ID, link2.L2ID
So, if I delete a master.MID the many L!ID's and L2ID's will also be deleted.