>I need to sort data in ascending order in the Grid.
>I have created a key index(CDX) for the table to
>associate to the Grid.
>The problem is that I am still unable to view the data
>in ascending order after setting the index order
>eg. open database (databasename)
> select (tablename)
> set index to (tagname)
>
>Pls advise, thanks.

Have you verified that the index is what oyu think it is by setting order and browsing the table?

How are you assigning the grid's recordsource? In the property sheet, or in code? Is the table open in the form's DataEnvironment?

The following simple steps should make a table viewable in a grid in a specified order.

Create a form, and drop a grid on it.
Add the table in question to the Data Environment.
SEt the Cursor's Order property to the name of the index you created
Set the grid's redordsource property to the name of the cursor.
Run the form.