Script Trigger on Field change
I have job, labor, and fee tables in my database. I currently have a script that will add a fee when a job's labor total reaches $100. Sometimes there are errors in data entry and that total could drop below $100. When that happens I need a way to delete the fee record that was created. This might need to be done when a labor record is deleted or when the amount in the labor record is modified. I'm pretty sure I can do it when the record is modified but I'm not sure how to run a script when a labor record is deleted. Is there a way to run a script when a record is deleted?