>Nadya,
>
>Yes, I know the deleted() does not work (see towards the bottom of my first reply). The record validation is not invoked when a record is deleted.
>On the other hand, the trigger is invoked for a delete but won't let you changed the record.
>
>
>options
>(1) Do you need the D ? can you test for deleted() ?
>
>The record validation fires when a deleted record is recalled.
>
>In short, the record validation is only fired when the contents of a record have been touched or record recalled
>
>Why do you need the D ?
>

In all our tables we have ModiType field with 3 possible values in it (A/C/D). These flags are updated in a complicated code. Another table has this field as well, so I thought, it would be a good idea to keep the same convention here. It looks like this update could not be done automatically on Table Level, so I have to put a special code in Delete method of the form...


>(2) keep a log table somewhere. this can be done with the triggers, although I'm not in favour of that for just a flag
>
>(3) Instead of a flag, add 2 datetime fields, One for dateCreated, and one for DateLastModified (Overkill)
>
>
>(4) ???
>
>>Hi again,
>>
>>It works, but deleted() doesn't work, e.g. I can not automatically set a "D" flag.