Set et al,

S> in general I think updating of other tables ought to be done in AFTER
S> INSERT/UPDATE triggers, not BEFORE INSERT/UPDATE, but if you ask me why, I
S> have no idea.

One reason could be it's just a logical sequence: you update a total
when a quantity has changed, not just before you change it.
Another one: less things to undo in case the insert/update goes
wrong.

Ciao
--
Nando mailto:nandod@...