Refreshing calc (sum) fields
- From: Carla <carla_sloan@xxxxxxxxxxx>
- Date: Wed, 5 Dec 2007 10:05:51 -0800 (PST)
In a "Bookings" table, I have a calc field, "TotalBookingCost", which
is defined as "sum ( BookingLines::BookingLineCost)", i.e. it's the
total of the costs of the individual lines that make up the booking.
BookingLineCost is also a calc field, based on rates, duration, etc.
I have a layout based on Bookings, with a the related BookingLines in
a portal. All well so far. But if the individual costs in a
BookingLine change in the portal, the value in TotalBookingCost is not
updated.
It seems I can force a refresh by a variety of means, such as toggling
the Status Area off and on, switching to a different layout, etc., but
I'm sure I shouldn't have to. Any ideas what I'm doing wrong?
(FM9, PC)
Carla
.
- Follow-Ups:
- Re: Refreshing calc (sum) fields
- From: Carla
- Re: Refreshing calc (sum) fields
- From: Chris Brown
- Re: Refreshing calc (sum) fields
- Prev by Date: Re: sliding in FM 7 not working?
- Next by Date: Re: Refreshing calc (sum) fields
- Previous by thread: how to get tables list from ODBC + Active Server Pages
- Next by thread: Re: Refreshing calc (sum) fields
- Index(es):
Relevant Pages
|
|