Return to FileMaker.com
Limit search results to a set number of records - How?
I have a large database and wish to search for the first x number of records.
In SQL, my query would be something like
"SELECT field1, field2 FROM table1 WHERE dateField >= today ORDER BY dateField LIMIT 10"
Is it possible to limit the results similarly in FMP?
After performing the find, you can use Omit Multiple Records to omit all but the first N records.
Go To Record/Request/Page [ N ; no dialog ]
Omit Multiple Records [ Get ( FoundCount ) ; no dialog ]
Retrieving data ...