You can not update the same table in the trigger. It can only be done in the table validation rule.

Re: Last Updated User Thread #988451 Message #989719

>Hmmm....
>
>I'm getting a syntax error when trying to place this into the expression builder for the table update trigger:
>
>IF OldVal('ActiveUser') = .T. AND ActiveUser = .F.
> REPLACE ActiveUserChg WITH DATETIME()
>ENDIF
>
>I've also tried adding RETURN .T. to the end, but still getting a syntax error
>
>Thoughts?