>Hi All,
>I have "nStndCost" field, that holds a Standard Cost of the product, and dStndCost (smalldatetime) field in my "Inventory" table.I want to make sure that if the value of the "nStndCost" field is changed by anyone, the dStndCost field (smalldatetime) will change its value to the current date time.
>I cannot update field values it in the AFTER UPDATE trigger on the "Inventory" table. Where can I trigger the change?

The AFTER UPDATE trigger is only place where you can do that.