CURSOR/INSERT HELP!

[mbrent]

Background: I have two tables. One is listed tabular on the canvas. For each record on this table that is changed, I want to insert a new record into the other table with the changed data from this table.

Ok, I was told to use a cursor to look at each record in table one and insert a new record into table two after each one.

I don't know if this is the correct way to go about this. I am terribly confused and cannot find a helpful example anywhere. I would appreciate any advise/help I can get.

Thanks!

 

[sem]

Create post-update trigger on the first block.