This is called storing derived data and it's a Bad Thing. (tm) It
denormalizes your schema. The real problem is that derived data stored in a
field has a tendency to get out of sync with the data it is derived from.
Therefore you end up writing programs that wipe it and put it back in sync
and all
On Sunday 15 December 2002 17:08, Beauford wrote:
> I have two tables, one with peoples names in it and one with data
> associated to these people. What I need to do is to be able to
> automatically total certain items in the data table that correspond with a
> name in the first table and then upd
