I just found out one may not index a table buffered View. I need to be able to reoder data currently in a view without having to requery the back-end because the user may have made 1 or 2 changes but what to view records in a different order before taking the next action.

SET ORDER TO needs the views to have been indexed first. Buffered tables may not be index.

Any ideas how to get round this?

Thanks

Mathias