Re: Calculated value dilemma
Date: Wed, 16 Jul 2008 20:17:31 GMT
Put the balance on the parent table. But also create a method of double checking that number by adding up the individual transactions, telling the user there is a problem, log that problem so they can bring it to your attention at a later date and then fix the balance. Also create this method before even coding the logic to update the balance. Thus you can use it as part of your testing.
-- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/Received on Wed Jul 16 2008 - 22:17:31 CEST