Refreshing calc (sum) fields



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
.



Relevant Pages

  • Re: Expedia.com overcharges for room reservations
    ... Selling a room through a third party always costs more. ... Some systems generate extra booking. ... even the big hotel chains are going to offer the best rates on ...
    (rec.travel.europe)
  • Re: How Soon To Book Flight?
    ... We are planning to drive for our cruise in September, but since booking it over a year ago, I've periodically checked airfare just to see if there were any bargains. ... We discussed it last night and actually came close to booking flights, but the schedules is not so good and ground transportation between MCO and the Port will add some costs. ... If we drive, gas will cost me around $120, but if we fly, it would be $350 for the not-so-good schedule, or almost $500 for a better schedule, then we'd spend around $100 on a couple of one-day car rentals to get back and forth from the port. ...
    (rec.arts.disney.parks)
  • Re: Refreshing calc (sum) fields
    ... 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 ...
    (comp.databases.filemaker)
  • Re: Refreshing calc (sum) fields
    ... total of the costs of the individual lines that make up the booking. ... I have a layout based on Bookings, with a the related BookingLines in ... main layout that does a simple "Refresh window", ...
    (comp.databases.filemaker)
  • Re: Rod Stewart model railway
    ... Nigel Emery wrote: ... Swiss flavour. ... Next booking for the layout is supposed to be Trainwest ...
    (uk.railway)