I have two databases, the first is a manufacturers database and the second is a database with every item sold with information such as the price and manufacturer code. In my manufacturer database I have a layout (viewed as a list) with a portal to find all line items with the same manufacturer code as the current record (there are about 50 total codes). That part works great, when I browse that layout it shows a summary of all of the sales from each company. I then have another leading grand summary at the top with a summary field that sums up each individual manufacturer.

The problem is that it doesn't update consistently and I have a date range implemented. If I open the database and search for all sales for last year the top summary field works out and will show the correct value. Then if I change the date range, each manufacturer total will update correctly but the grand total at the top stays the same.

I have found one way to fix this but need a better solution. If I open up the Define Database screen and change something and then hit OK it recalculates, but thats very inconvenient for my users.

Thanks in advance

I have two databases, the first is a manufacturers database and the second is a database with every item sold with information such as the price and manufacturer code. In my manufacturer database I have a layout (viewed as a list) with a portal to find all line items with the same manufacturer code as the current record (there are about 50 total codes). That part works great, when I browse that layout it shows a summary of all of the sales from each company. I then have another leading grand summary at the top with a summary field that sums up each individual manufacturer.

The problem is that it doesn't update consistently and I have a date range implemented. If I open the database and search for all sales for last year the top summary field works out and will show the correct value. Then if I change the date range, each manufacturer total will update correctly but the grand total at the top stays the same.

I have found one way to fix this but need a better solution. If I open up the Define Database screen and change something and then hit OK it recalculates, but thats very inconvenient for my users.

Thanks in advance

I have two databases, the first is a manufacturers database and the second is a database with every item sold with information such as the price and manufacturer code. In my manufacturer database I have a layout (viewed as a list) with a portal to find all line items with the same manufacturer code as the current record (there are about 50 total codes). That part works great, when I browse that layout it shows a summary of all of the sales from each company. I then have another leading grand summary at the top with a summary field that sums up each individual manufacturer.

The problem is that it doesn't update consistently and I have a date range implemented. If I open the database and search for all sales for last year the top summary field works out and will show the correct value. Then if I change the date range, each manufacturer total will update correctly but the grand total at the top stays the same.

I have found one way to fix this but need a better solution. If I open up the Define Database screen and change something and then hit OK it recalculates, but thats very inconvenient for my users.

Thanks in advance

The purpose of the summary fields is for generating reports. If you want the summary field to update you must leave the layout containing the summary field and then return to that layout. This will allow the summary field to recalculate its total.

Another option:

1) Use an unstored calculation field that uses the SUM() function.

2) Create a relationship that will allow you to sum() the related records.

Example:

Field Name "Amount"

Relationship Name "AmountSum"

Unstored Caculation Field Name "c_Sum_Amount"

Unstored Calculation = sum(AmountSum::Amount)