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

    Data model calendar

    David Koschei

      Hello,

       

      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