Newbies newday Posted February 2, 2005 Newbies Share Posted February 2, 2005 I have a script that does the following: - show all records - sort by date (so most current date is last) - go to last record and date field Now, based on the contents of that date field, I want to do a second FIND to return all records with that date. (The reason... sometimes we do our billing and need to unmark the most current billing print date for various reasons. I would be adding the script to a button so anyone can do it without having to call me). Link to comment Share on other sites More sharing options...
-Queue- Posted February 2, 2005 Share Posted February 2, 2005 Create a Cartesian self-relationship (using the X operator, so that all records are related to one another) from serial to serial and define it to sort by date descending. Now, relationship::date refers to the most recent date. You can either set this in a global date field and perform a find based on it or create a relationship from a global date field to the date field, set the global with relationship::date, and Go to Related Record [show only related; "relationship"] to isolate all records with that date. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7150 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