Anand,
Your best option is to use a parameterized view. The view can have any order you want, and if it is index you can change the order at runtime with code in the Header.Click(). In the combo.Valid() you simply call Requery( "TheView" ) and .Refresh() the grid. If you've never used a parameterized view before check the Help file, solutions.app and go have a look at the article on my website under Q&A, Forms.
>i have
>group table with primary key groupid.
>product table with primary key productid & other index is groupid.
>
>in dataenvi of form i added these two table with groupid relation.
>
>on form combo display group tables entry &
>grid displays product fields related to group table.
>
>it works ,but problem is grid doest not display data in productid order.
>
>i try to changed order of productid cursor in dataenvi of form,but it
>still display in product.groupid order