Help with isql - Moving results from Detail to Master table

We have the need to pass data that has been entered into a detail table to be moved to a master table. We are not sure if a trigger should be used or what. We don't find a lot of help from our manuals on using a trigger. Here is the situation: REPORT (Master Table) rep_date_completed rep_status_code REVIEW (Detail of REPORT) rev_date_completed rev_status_code A number of reviews are made (normally in series) about the report. The number of reviews can vary. A reviewer, who is designated as final, will issue a COMPLETE status code. However the process may not get that far since a status code (like CANCEL) can be issued from any of the prior reviewers. We want to pass the status code and the date_completed from the appropriate Detail to the Master table. We are mainly interested in the final disposition, but if interim results (each reviewer) need to be posted to the master in order to make the trigger or whatever work, then so be it. We are limited to isql on the SE. We do not have 4GL.