sql update trigger that updates table 2 when table 1 is changed

[garymarshallsa]

I am new to SQL and have a MSSQL 2000 database data_02 that consists of two tables

Table1 oeordhdr_sql fields ORDDATE
Table2 oeordlin_sql fields REQDATE, SHPDATE

I am needing a trigger that when table1 oeordhdr_sql field ORDDATE is updated that the table2 oeordlin_sql fields REQDATE and SHPDATE are updated to the same date updated in table1 oeordhdr_sql field ORDDATE. Can this be done

[ck9663]

Here's a primer.

-- CK