I've set up a database of inventory, and I'm trying to find the top 200 selling items. I can sort by "items sold year to date", as an example, but I want to limit the list to only 200 records total.

I don't know how to do this without going manually to record # 201 and then performing a find of all records smaller than "X" qty sold YTD, and deleting those records, and then printing out my report.

Any suggestions qould be appreciated.

Longtime Nutshell User, New Filemaker user

In your script you could say...

Go to record/request/page [by number, 201]

Omit Multiple [big number]

I don't believe there is a way to say "omit this and everything after", but I think it will work if you just put in a really large number (I'm assuming it doesn't go back to the beginning or anything funky like that).