5 Replies Latest reply on Jan 29, 2016 7:26 AM by richardsrussell

    use of Tables Relations to display only selected Date Range

    Powerbook

      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.