2 Replies Latest reply: Apr 1, 2013 11:24 AM by David Koschei RSS

    Data model calendar



      I have 3 tables.

      Defect: DetectedDate, ClosedDate

      Request: RequestID, OpenDate, ClosedDate

      TimeLog: RequestID, LogDate


      I want to use a master calendar to persist date selections in my reports using Defect.DetectedDate, Request.ClosedDate, and TimeLog.LogDate.


      The issue is that I also want Request.RequestID to join with TimeLog.RequestID.  How can I achieve both?


      Thank you