Re: can a field reference the sum of a field in another table?

In article <2omkg0t45qhk17bkuttsrsmp2lggo963il_at_4ax.com>, sybrandb_at_hccnet.nl enlightened us with...
> On Fri, 30 Jul 2004 08:09:57 -0500, kaeli
> <tiny_one_at_NOSPAM.comcast.net> wrote:
>
> >Hey all,
> >
> >I'd like to make a table with a field that references the sum of another
> >field in another table. I know I could use a view for this, but it would be
> >more convenient if I could do it right in the table. Is that possible?
>
> If you want to violate normalization rules, and start your route to
> hell, yes definitely.
>
>

Would you care to elaborate please?

-- 
--
~kaeli~
Contrary to popular opinion, the plural of 'anecdote' is 
not 'fact'. 
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace