AnsweredAssumed Answered

use of Tables Relations to display only selected Date Range

Question asked by Powerbook on Jan 29, 2016
Latest reply on Jan 29, 2016 by richardsrussell

I have the following problem to solve.


I have a TABLE1 that contains 2 fields

"StartDate" and  "EndDate"

and a second table TABLE2 that has a field "CurrentDate".


Is there a way to relate this two table so that in the Table 2 are displayed only records of "CurrentDate" that are within the range "StartDate" and "EndDate"?

I also know that could do what I need with a Script that runs once I open a Layout.

But I would prefer to lock globally the range of record that are displayed from the TABLE2. So that if any new layout calls this table, I do not need to run a script.

Thank you for any help in advance guys.