AnsweredAssumed Answered

portal doesn't dynamically update when relationship based on calculation

Question asked by robdownunder on Jul 3, 2011
Latest reply on Aug 14, 2014 by Porpoise

Title

portal doesn't dynamically update when relationship based on calculation

Post

I have a portal that is based on a key field and an event date.

In the main table, I have a changeable event date, let's call it date_X that is used in the definition of a portal. A record in the portal matches if its event date is before date_X (defined in the relationship graph, not as a filter).  So the portal shows all records before date_X.

date_X is based on a calculation that's just a copy of a global field in another table.

When date_X changes, the portal doesn't update unless I do work in the relationship graphic and then exit back to the layout.

If date_X is changed to be a static date field, everything works as expected.

Is there any way to make the portal update automatically ?

thanks,

FM Pro 11, Mac OSX 10.6

Outcomes