chapeau_melon Posted November 17, 2006 Share Posted November 17, 2006 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 ;) Link to comment Share on other sites More sharing options...
comment Posted November 17, 2006 Share Posted November 17, 2006 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). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6368 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now