In addition to Erik's message, it is important to realize that once you create an index on a view, as long as you do not close the view, the index gets automatically rebuilt when you requery: you dont have to keep indexing.

>I want my grid to be sorted based on the header the user clicks on. I am using a view to populate the grid.I am also using transactions in my form, so using indexes would create alot of extra coding. What is a good way to do this?
>Thanks,
>Jill