I have a sum calculation that's behaving a little weird on me. The calc is a simple sum of a related field: sum(shipments::units). The relationship is based on a code and on a boolean received field. Only shipments that have been received are related.

If I change the value of shipments::received the sum changes correctly, but on one of my layouts the fields don't refresh and on another one it does. At first I thought it was that one was in list view and the other was in form, but after doing some testing I figured out what the difference was: the layout that refreshes has a portal on it showing the related shipments, the layout that doesn't refresh only has the sum.

Is this a known or common problem? Is there a workaround? The refresh window script step doesn't work, but changing layouts and going back does. I could stick a small invisible portal in the layout, but... I'd like to find a better solution.

Any thoughts?

Try setting the key field for the relationship to itself. This is often used to force an update.

The relationship has two key fields: code and received. So I already am changing the received field and the calc isn't updating. Should I set the code field to itself? Or are you talking about setting the key field in the other table?

I'm relating the inventory and shipments tables and changing the value of shipments::received, so maybe I should update the value of inventory::code?

I would think setting the related key would probably work best. But I haven't had much experience with this in 7. I'm only going by what I've read from others' experience.