November 17, 200619 yr 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 ;)
November 17, 200619 yr 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).
Create an account or sign in to comment