Jump to content

Second Find based on First find/sort


newday

This topic is 7078 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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

This topic is 7078 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.