Joseph31 Posted April 16, 2004 Share Posted April 16, 2004 I have a portal that hold a subject line and a date line...they are lined by the company name. Really a call log that I made. All I want to do is have the most recent date (newest entry) show up on a differnt form and maybe a report. Is there a simple way to do this. FileMaker Version: 6 Platform: Windows 2000 Link to comment Share on other sites More sharing options...
BobWeaver Posted April 17, 2004 Share Posted April 17, 2004 If you sort the relationship by the date field in descending order (or create a duplicate relationship with this sort order), then place a related record on your layout (without a portal) then the data from the related record with the most recent date will appear in it. Link to comment Share on other sites More sharing options...
RalphL Posted April 17, 2004 Share Posted April 17, 2004 Use the Max or Last function. Link to comment Share on other sites More sharing options...
Joseph31 Posted April 19, 2004 Author Share Posted April 19, 2004 Thank you again....I will let you know if I can make it work. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7305 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