Hi There,

I want to show a list of records in a portal with the following condition:

When a invoice is overdue I want to show it in a portal. The problem is that the relationship that is needed must be a calculation that is not saved, because else it won't be calculated every time the date changes. Calculations that are not saved cannot be indexed and therefore cannot be used in a relationship.

How can I bypass this problem.

I'm using FMPRO 8 advanced v2

I'm from the netherlands and hope that the above discription is readable. It is been I while since I wrote English!

Only the target field must be indexed. That would be the "DateDue" in the line items. The date field used as portal filter (on the "left-hand" side, as we used to say in 6, the parent, originating side) would be something like: Get (CurrentDate) - 30

Storage Options, Do not store

This would be in the parent table.

AND whatever other fields for the relationship, if any.

It may have refresh issues if you leave the portal visible all night -]. But otherwise it should be all right I think.