>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

The only way to do this is by indexing the view. How is an INDEX statement a lot of code?

Transactions shouldn't have any impact on what you are trying to do, just make sure that when you issue your INDEX commands, the view you are indexing has its buffermode set to 3: row buffering.