Hi Anand,

Open the DE, select the table in question and set the ORDER property in the properties sheet.

>Hi
>
>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
>
>anand