>>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.

Thanks for the advise. I have tried the method you suggested,
but still could grt the effect.
Yes, I have include the table into the Data Environment and all
that you suggested, but still could work.
I tried using the Command Box(in VFP) to open the table and
set the index tag and Browse, it is in order, but when I put it
into Grid, it doesn't seems to behave properly.

In Grid, RecordSource = (tablename)
RecordSourceType = Table
BTW, the Grid was placed in the PageFrame.

Anywhere could went wrong?