I have a database which records lots of information as a daily record with child records that all have the Date record as the parent record. One of the things that I keep a log of is our daily cash movements. We used to just keep a long list which is a bit cumbersome and prone to errors so I have now set up a child record of cash movements but still need to keep a running total. The idea is that entries are made in a portal and not a report layout but I can not get the portal records to update because the summaries and calculations only look at the current context, i.e the records on that particular day. Is there a way to do this, maybe I need a different relationship.
I know I can probably send the script to the list view do the calcs and then come back again but it seems over complicated. I have uploaded an extract from the relationship diagram.