Method Community

I built a new screen, displaying a grid based off of the transactions table. I'd like to use the SQL override function to allow for a summarized view of transactions by account.

After watching the finer points of the webinar, my main problem is that I can't add a new field to the Transaction table. This field is needed to insert the Action Result (sum) into. 

How can I get around this? 

AutumnW:

How can I get around this?

Unfortunately there is no workaround for this - Transaction is the one table we lock down to prevent editing.  You'll have to tackle this screen in another way - possibly looping through the transaction table to get the information you need and storing that in another table for lookup.  

~C