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 update
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