Single Category View and column totals

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:

  1. 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.

  2. 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

Subject: Single Category View and column totals

Create a second category below the top category. The top row of your embedded view will then be a category - you can give it whatever column value you want, I usually just make it the same as the single category - with totals for the view

Subject: RE: Single Category View and column totals

Hi Dan,

Do you mean create a new single category view below the orginal one, set the category to the same as the original view and then stick a column into the view to total the amounts?

Subject: RE: Single Category View and column totals

Exactly