We have a about 200 entries and we have to use a 'Grid' setup to display 25 entries at a time. But user wants to be able to sort the grid on any one of the 5 columns. But the sorting should sort the entire 200 entries.

We also need to use the COMMAND mode as the entries may be added/deleted/updated.

This is a very tricky situation, not sure how to handle this.

Any help is very appreciated!