auto-update date/time when row is updated

[HaveTrouble]

I have a date/time field in one table. Is there a way to make this date/time field auto-updated to current date/time whenever the row is updated ? I have queries everywhere to update this table so change the query to update date/time field is not an option for me. Please help.

 

[jbenson001]

How about and UPDATE trigger?

 

[HaveTrouble]

Ya, I think I can use that. If I have 2 relational tables - say 1 (master table) store order information such as customer name, address, etc, and another store items ordered. Order number is the key between 2 tables. When items table is updated, I need the timestamp on master table to be updated. How can I achieve that ?