May 29, 200817 yr 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
May 29, 200817 yr Author 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.
May 29, 200817 yr Why would a date in the Payment table change? Once the payment is made, it's done, right?
May 29, 200817 yr 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, 200817 yr by Guest
May 29, 200817 yr Author 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.
Create an account or sign in to comment