IMNSHO, never store dynamic data in a field unless you absolutely have to.
There are going to be exceptions, but unless a manager is going to participate
in hundreds of thousands of fixtures I don't think this is one of them.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>From: Tompkins Neil [mailto:neil.tompkins@stripped]
>Sent: Wednesday, September 01, 2010 4:29 PM
>Subject: Best method to keep totals
>I'm developing a system whereby a manager gets assigned points based a
>certain number of factors which are saved alongside a football result.
> However, I also want to keep a total for each manager. My question is it
>best to just have a query that uses SUM to total the managers points gained
>for each fixture participated in ? Or should I be looking to have
>a separate field which is the calculated total for each manager ?
>Thanks in advance for any advice.