chan.onna

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

Discussion created by chan.onna on Apr 22, 2014
Latest reply on Apr 23, 2014 by 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

 

 

 

 


Outcomes