when a user adds a record in the company table and <BR>eg a record is created with the index of 526 I want a trigger <BR>to make an insert into the DataInsert table with a value of<BR>526 going into a field called intCompany .. how do i code this<BR>msdn is not good on sql .. cheers in advance