>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.
Yeah, after thinking about this, I think you're right. I hate duplicating data, as it has always seemed to cause my trouble in the past < g >, but this looks like a time to bend the rules.
Chris McCandless
Red Sky Software