We have reached the maximum number of records in our existing table (max size 10,000) and it will no longer show all records. We have to filter to find what we are now looking for. I am wondering if there is a way to archive prior year records or move them to another table?
When the table home page is set to the default report, you get the default behavior.
The default behavior is as Matthew described,
But if you change your table home page report to be a report, even the List All report, then it will continue to behave as it used to with the full report and a filter box. The assumption is that if you consciencly choose the list all report and knowing choose to take the risk of slowing down your app, then that is your choice.