I have a need for the view in a grid to display in different orders depending on the search criteria that has been selected. I'm under the impression after reviewing past threads that there is not a way to do this through the project interface, but may be possible progmatically. I keep getting the message that I'm not allowed to create indexes on views for buffered tables. I've considered using multiple views (only the order being different) for the grid source, but that would ineffiecient for a number of reasons that I can see. What is the correct way to handle this? Thanks!

Regards, Renoir