Jump to content

Auto show of overdue invoices with calculated relation


Intered

This topic is 6580 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6580 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.