Caps on Collections
When you retrieve records for a collection, a record cap limits the number of records that can be returned. You should consider this cap when you retrieve a collection for which the size might exceed the cap.
Finding the Current Cap on Collections
If you know you need to retrieve a large number of records for a collection, you can find out whether the current cap will allow you to display that number of records. For more information, see Viewing the Current Cap on Collections.
Identifying When You Have Reached the Cap
Knowing whether you have reached the cap on records is fairly straightforward: The number of records in a collection shows in the status bar in the lower-left corner of the application window.
To determine whether a collection contains the maximum number of records allowed, compare the number of records retrieved (the second number) with the current cap on data records.
The button on the tool bar navigates to the last record displayed, not necessarily the last actual record in the database. You can use this to help determine when a collection contains the maximum number of records allowed but not all potential records that match your filter criteria.
The button on the tool bar also provides a visual cue as to whether there are more records available. If the double arrows are blue, then there are more records available.
Retrieving Additional Records
If you have a collection that does not display all the records you need, try replacing the current collection with a collection filtered using more specific criteria. You can use any of these options:
- Do a more focused Filter-in-Place query.
- Use the button on the tool bar to retrieve and display the next set of records.
- Use the associated query form to perform a more refined query.
In most cases, you should be able to get the collection you are looking for by one of these methods. Only if these methods do not return the collection you need in full should you increase the cap on records.