I have a calculation that uses future (planned)invoice record totals. These future invoice records are presented to the user via a portal. When a future invoice record (located in another file) is deleted from the portal (delete portal row button)the calculation doesn't immediately update. However, if you change the invoice total in the portal the amounts update. This seems strange. In addition, after deleting a record, the calc field will show the result of the deletion once another field being used in the calculation is changed. I don't know is this is important, but I am using a "sum" operator in the calculation.

Please help. I would like the deletion of a record to immediately register in the calculation field. Thank you for reviewing my question.

-Todd

I found a solution to my problem. Thanks.

Hi there,

I have a similar problem, so your solution might help me.

Here is my situation.

I have an invoice, and it is composed of 2 files :

- The header file which contains a unique invoice number, the client info, number of pages, and the invoice sub-total, taxes, grand-total.

- The line items, related to the invoice by the unique invoice number, items, and price.

I have a relation called LINE_ITEMS (from header to line-items) by header.invoice#=line_items.invoice# .

Now, the header sub-total is calculated by Sum(LINE_ITEMS::price). This works well when I look at it directly from the header file; it is updated correclty when I change the line items.

HOWEVER, I use a third file to look at the invoices. In that file, I have a relation to the header and the line items so that I can see everything.

When I change the line items, the price no longer updates, unless I click in the sub-total field. Attached is an example of the files I am using.

Thanks for any help,

Marc

Version: v5.x

Platform: Windows 2000

Update_Calc.zip

Quite often, to get portals to update properly you have to execute a script step such as Exit Record, or switch to preview mode and then back to browse mode.