Mike,

What u are suggested is right. But i didnt get "reorder the grid using the indexes on the view". Is this means sorting views? and if yes then again problem goes to the main question. Can u show me dummy code.

Regards
Amit




>Hi Mallari,
>
>That's why I suggested using the view. Your form loads the view nodata. You add indexes like the others are suggesting to the view. Your users specify what data they want and requery. They can also reorder the grid using the indexes on the view. This way, you don't put such an index on the table, but you provide the feature you're after.
>
>Mike