In the DE.OpenTables try the following (assuming VFP5):
DODEFAULT
SET ORDER ...
=============================
>Kamal and Carlos,
>
>Help, I can't do it either way!
>
>I tried SET ORDER TO TAG
DESC and when I run VFP says "Variable CALL_DATE does not exist". I believe it is because at that moment the table hasn't been opened yet. There is not unfortunately a "AfterOpenTables" event in the data environment.
>
>However, I also try Carlos' second technique, namely: "SET ORDER TO TAG DESC IN " in the form init, and that time I seem to lose the child data in the grid.
>
>The darned thing thing I was able to do it once, but made some changes and lost my way.
>
>Alex
>
>>
>>Though instead of specifying the order you could put the following :
>>*-- DE.Cursor.Init()
>>SET ORDER TO TAG YourTag DESC
>>
>>
>>>Is there a way in design mode, to set descending order to a cursor in the DataEnviro of the form?
>>>Now i must do one of those things:
>>>1.- Create two index tags: one ascending, another one descending
>>>2.- Issuing in the init code of the form 'set order to mytag descending in myalias'
>>>
>>>Thanks.
>>>Carlos.