http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/12437.aspxFri, 25 May 2012 15:03:49 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:12437Anonymous0http://forums.method.me/cs/forums/thread/12437.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=12437<p><BLOCKQUOTE><div><img src="/cs/Themes/methodtheme/images/icon-quote.gif"> <strong>AutumnW:</strong></div><div>How can I get around this?</div></BLOCKQUOTE></p> <p>Unfortunately there is no workaround for this - Transaction is the one table we lock down to prevent editing. &nbsp;You&#39;ll have to tackle this screen in another way - possibly looping through the&nbsp;transaction table to get the information you need and storing that in another table for lookup. &nbsp;</p> <p>~C</p>http://forums.method.me/cs/forums/thread/12428.aspxThu, 24 May 2012 22:48:31 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:12428AutumnW0http://forums.method.me/cs/forums/thread/12428.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=12428<p>I built a new screen, displaying a grid based off of the transactions table. I&#39;d like to use the SQL override function to allow for a summarized view of transactions by account.</p> <p>After watching the finer points of the webinar, my main problem is that I can&#39;t add a new field to the Transaction table. This field is needed to insert the Action Result (sum) into.&nbsp;</p> <p>How can I get around this?&nbsp;</p>