After Update Trigger

Gents,

I am trying to update records in a table based on the values being put   in by update into another record in the same table. The fire-after-update trigger on the table will not allow this. How may I go about doing this?

update tblfoo set field1=foo,field2=bar where foo_id=1;

In the fire-after-trigger I want to update all records eg..

update tblfoo set field2=bar where foo_id <> 2 and field1=foo;

Thanks Received on Sun Apr 09 2006 - 21:35:58 CDT