Updating Threshold Data without losing History

Hello! I have a table which contains daily orders by item, by location, by date.  I have another table which counts the # of lines of the daily orders along with the total cost of those orders at t...