A trigger inserts a record in the t_hispieces table. This works fine already. I just need to adapt the trigger (see [login to view URL] file which is attached) so that when a record is inserted in t_hispieces, a record is also be created in t_custdoffs. The data for the two records should match but the t_custdoffs record will only contain the following fields (which are also part of t_hisieces): c_Machine_Nr c_StartTime c_EndTime c_Job c_Piece c_ProductionCount02 c_Product c_OperatorName The primary key for the t_custdoffs table is c_piece,c_starttime.
## Deliverables
1) Modified Procedure (in a .txt file).
2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2000 Server Oracle 8.1.7