Is the field you are updating in the same table? You cannot do that via a trigger then. Think about it: the trigger fires, and then changes a value in the same table, which fires the trigger, which changes a value in the same table, which fires the trigger, ... in other words, and infinite loop. You can update a separate table in a trigger, but not the table on which the trigger is firing.
== Ed Leafe