Hello,

I need help with a portal that will update automatically every time users open the file. I am using a global field in table [To Do List] and a text Field with an auto enter calculation in table [To Do List 2].

This works fine if you update the Due Date Field manually. The problem is I have over 2,000 records in the table and this number is expected to increase fast.

The idea is to automatically display records with the following conditions [Do Dates] < [Current Date] and incomplete tasks in the portal.

Please advice me what will be the best way to accomplish this task

Thanks.

To_Do_List_Copy.zip

You should not try to calculate the match field based on the current date. Instead, put the current date on the parent side of the relationship. This way the child keys don't need to be recalculated. See attached.

To_Do_List2.fp7.zip