Duane Boudreau wrote: > > I have a db (MSSQL) with the following tables: > > Position Questions Response > position_id question_id response_id > position_id question_id > > I need to design the triggers that will automatically delete related records > from the question and responses table.
If I understand your table layout correctly, you should be using FK constraints with ON DELETE CASCADE. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm