automatic updation of one table if data inserted in another table

<i><b>Originally posted by : vegobha (vegobha@hotmail.com)</b></i><br />i am using sql7<br /><br />Is it possible to insert the values of some columns of one table into another table automatically. If so guide me. <br /><br />For ex. I have a table table1 with 5 columns (a,b,c,d,e)<br />i inserted data into them.<br /> simultaneously i need to insert 3 columns data (say a,b,e) into table2.<br />Thanks in advance

<i><b>Originally posted by : Sean</b></i><br />just do a trigger<br /><br />------------<br />vegobha at 4/26/2000 2:44:57 PM<br /><br />i am using sql7<br /><br />Is it possible to insert the values of some columns of one table into another table automatically. If so guide me. <br /><br />For ex. I have a table table1 with 5 columns (a,b,c,d,e)<br />i inserted data into them.<br /> simultaneously i need to insert 3 columns data (say a,b,e) into table2.<br />Thanks in advance

Or (if applicable) use Referrential Integrity