Re: Delete record with backup

[paul alcock]

Thanks Chad - every question leads to new learning :)
Never used triggers before, thanks for pointing them out.

Am I on the right track here?

So something like this
CREATE TRIGGER ActiveDeleteCapture
BEFORE DELETE FROM `Actives`
INSERT INTO `Actives_Deleted`
SELECT * FROM `Actives` WHERE `Actives`.`A_key` =OLD `Actives`.`A_key`
;

TIA again.

Paul