display latest date

[madman411]

I have two tables:

 

Table 1 contains all our company products ("Assets"). Table 2 contains all the Quality Control ("QC") entries pertaining to each individual asset. On one layout I am currently displaying all our assets as a List, and the user has options to search and filter the assets on this layout. When a QC entry is made for a particular Asset, the QC record is time and date stamped. The user is able to search the Assets by date (to show what was QC'd on what date, etc). The search feature works great, however the Asset list also displays the Date Stamp field from the related QC table so the user can actually see the date of the latest QC entry without needing to open the Asset record further. I am running into the issue where the Date Stamp field is displaying the first QC date that exists for the Asset rather than the latest date. Is there a way to have FMP display the latest date of the related record?

[Matthew F]

In the relationship graph between Assets and QC, select the box "Sort records" for the QC table.  Place the Timestamp in the sort order, and then select "Descending order". 

[madman411]

In the relationship graph between Assets and QC, select the box "Sort records" for the QC table.  Place the Timestamp in the sort order, and then select "Descending order". 

 

You're awesome. I was expecting some form of calculation. I seem to have overcomplicated it