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.