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?