Line Item Total does not Refresh.

[purplemaji]

I think this will end up being a field definitions problem, but there might be some other voodoo involved.

I have a database where I need to display the total value of some related records. The value of each related record is the sum of some child related records, so I have 3 tables altogether. Something like this:

  Project

    - Tasks

      - Items

In 7, this works fine, although sometimes I need to refresh. In 8, when I update the child "Items", the "Task" records update, but the sum in the "Project" record does not. If I close the database and re-open it, all the values in the "Project" database display correct values, but when I make the change in the Item, nothing updates until I close.

How can I make the grandfather record ("Project") update when the child record changes?

Hope this was clear.

-pm

[-Queue-]

Try using a script (when on a 'Project' layout) with a Refresh Window [Flush cached join results] step.

[purplemaji]

Thank you, I added that script step, and the refresh worked the way I had been expecting it to (and the same way it did in 7).

Is that something that can be forced without using a script, or is that the only way to go about it?

Thanks again!

-PM

[-Queue-]

It may be a bug to be fixed in one of the next revisions. If not, then I think the script step is the only foolproof method.