Hi Everyone -

Simple question (i think)

I need to write a trigger that will update a different table
with the values that were just inserted into the table.

In short, i have a table that is being populated currently,
everything is well, now the customer would like a smaller
index type table based on the values that are being passed
into what will now be referenced as the detail table....

To eliminate a lot of business layer code changes, i would simply
like to place a trigger that updates the index table when an
insert occurs on the detail table.... but i am not sure on how
to get the values of the row that was just inserted, and insert
them into a different table...

please advise

take care
tony