Hi everyone,
I’m hoping someone could provide more / greater insight on an issue I am having with embedded, single category views. I know that column totals don’t show up within the view and that’s it’s possible to add up that total in a field on the parent form, which I’m doing using an @DbLookup, however there are two issues with this:
-
In order to get the total to update, I have to click on the main form and then hit F9, then the field calculates. I’d like this field to update as documents are added and deleted, thus updating the total, so I’m not sure how to refresh the parent when an action takes place that involves the parent document.
-
Is there a better way I could be doing this either from outside the view or from within the view?
Any ideas would be appreciated.
Steve