I have two related tables: Items(ID,...) and Transactions(ItemID,
Date, Quantity). I want to compute the total quantity of
transactions of an item before a specific date. So I add a global in
Items (gEndDate) and add another relationship Transactions_OnDate
where ID=ItemID AND gEndDate >=Date

I then add a calculated field in Items Qty_OnDate = Sum
(Transactions_OnDate::Quantity.

Everything works perfectly. I see correct records in both portals.
I am also able to search in the calculated field Qty_OnDate.

BUT when I move the database to server, portals and records display
correct amounts but when I search for Qty_OnDate >0 after changing
global gEndDate I get the wrong results: I get results of previous
search, as if the Qty_OnDate has not updated even though I see
correct results. If I make any changes to a record, then Qty_OnDate
is updated properly and that record appears correctly after find.

Any ideas?


Server FMS9 (9.0.3.326) (Mac), Client: FMPro 9.0v3 (Mac)






--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/