Don't know if you are working with MMDDYY or DDMMYY format here.
What criteria are you using to get the Found set you show?
abc 20 .50 09/20/09
abc 40 .25 07/07/07
In general terms, I think you'll need a script that sorts by date in descending order so that the date closest to today will be listed first. A script can then loop through the found set and use omit record to omit undesired records from your found set.
But I'm not clear on the big picture here. What are you trying to accomplish with this find. There might be a different approach that would get you the results you want more easily.
the date format is MMDDYY.
Essentially I am trying to make a script tied to a button that will search through all records for a P/N and show the records that are the most recent for each quantity and how much the piece price was on that date. The script also omits records in which no price is entered.
Also I am using FileMaker Pro ver. 8.5
I think you'd need to perform a find for your part number, then sort your records, first by quantity to group them by quantity, then in descending order by date so that the most recent is listed first in each group of records.
If you created a list view layout and changed the body layout part into a subsummary when sorted by quantity, you'd get a list that drops out duplicates and lists the most recent for each quantity.
Wow that was really simple thanks.