Trouble with unstored calc field and related records

[gaby78]

I am trying to show related records where the relationship is based on unstored calc. Please take a look at the attached file. Any suggestion will be highly appreciated.

Thanks

InvPmt.ZIP

[mr_vodka]

Why dont you have the date as a lookup?

[gaby78]

The trouble with lookup and autoenter calc is that if the date in parent (Payment table) is changed, Date in child table (Payment_Details) does not update. I currently have Date in child table as an autoenter calc and have a script that loops through portal records to reset the foreign key to itself to update the value.

It is a bit akward until I find a more elegant approach.

[David Jondreau]

Why would a date in the Payment table change? Once the payment is made, it's done, right?

[comment]

You could try the famous Ugo method (see attached).

---

NOTE: I have moved the cutoff date to the payment items table for better refreshing.

InvoicePmt2.fp7.zip

Edited May 29, 2008 by Guest

[gaby78]

Superb, thanks a lot Comment

Hello D J:

During data entry errors happen; also I found autoenter calc field in portal that draws data from parent is not 100% reliable, sometimes the value does not compute.