Display only limited records in layout
In my database table, I have 6000+ records from four different years. I have created a data entry layout to display this data and also view the data. I would like to display only records of one particular year at a time. Very rarely a user goes back to viewing previous years' data. Hence, I would like to display 1500+ records of the current year and then if the user wishes (say changes the value of an input field) then I would like to display other records.
Is this possible? Can you please tell me how can I implement this in FM Pro 11?