>>Hi Elyse,
>>
>>Why you not put a
trigger for delete that blank/nulled deleted records ?>>
>>Fabio
>
>I don't want to lose the information in the deleted records.
Deleted records should be treated as non-existent - this would save you quite a lot of trouble.
If you want to keep information, don't delete the record - mark it, by placing a certain value in a special field.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)