> I want to change a field of a record after the modification of another
> field of the same record or during an insert of a new record.
You can easily accomplish this in a BEFORE trigger. It is applicable for
both insert & update.
regards,
bhuvaneswaran