Hi Chris

However, the program could be modified to update an "onhand" table each time the fruits table is modified. The sql code would only have to be run if (when) something causes a difference, such as a power outage.