> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])