Link to latest date from portal

[chapeau_melon]

Hello,

I can't seem to find how to make a link between the results in a portal and a field outside that portal.

The portal contains dates from a table. These date are ordered. The newest date is up/the oldest beneith.

I want to display 1 (only the most newest) date in a other field not related to the portal.

And for shure, if the portal gets updated, that field must also be update with the youngest date.

Comprendo ;)

[comment]

Sort your relationship (not your portal, or not ONLY your portal) by date, descending. Place any related field outside the portal - it will show data from the record with the latest date.

A better arrangement would use auto-entered serial numbers instead of dates - because two records can have the same date.

Another option is to use a calculated field =

Last ( related::value )

This returns the value from the last related record (according to the sort order specified for the relationship).