Problem 1: Create a data macro that corresponds to a delete event on table OrderLine. After an OrderLine record is deleted, the macro will copy the deleted OrderLine record to a table called Deleted_Orderline, the macro then updates the OnHand value of the associated record in the Item table to increase the OnHand value by the same amount as in the deleted OrderLine record. Hint: you will use the CreateRecord action to add the deleted records to the Deleted_OrderLine table, and the LookupRecord and EditRecord\SetField actions to update the OnHand field in Item.

1. Determine the specifics of the macro: event, timing, event table, and response actions.

Create the macro. Hint: To quickly create table Deleted_Orderline (which has the same structure as table OrderLine), you can copy and paste table OrderLine and choose the Structure Only paste option.

Test the data macro by creating a triggering event. In other words, delete a record from table OrderLine. Check if the deleted record is copied to table Deleted_Orderline and if the OnHand value in the Item table is updated.