2 Replies Latest reply on Apr 23, 2014 7:13 PM by chan.onna

    How to create relationship to show max(date) for related record

    chan.onna

      Hi,

       

      I've tried to read through other similiar articles posted on this, but can't seem to figure out how to accomplish this:

       

      There are two tables I'm trying to work with:

       

      Table: tblReport

      ReportID

      Report_Name

      Report_Description

      Report_Module

      Report_Sample

       

      Table: tblReportHistory

      ReportHistoryID

      ReportID (joined to tblReport)

      ReportHistory_ClientNumber

      ReportHistory_InstalledDate

       

      I'd like to create a layout that shows just the most recent ReportHistory_InstalledDate / Max(ReportHistory_InstalledDate) for each ReportID:

      Report_Name,

      Report_Description,

      Report_Module,

      ReportHistory_ClientNumber,

      ReportHistory_InstalledDate

       

       

      I'm new to Filemaker, so any advice would be greatly appreciated!

       

      Thanks so much!

      Anna