>Can you use an INDEX ON statement to achive that? (If I'm missing the point, you might be able to find what you need under cursorgetprop or dbgetprop in help)
>
>>I'm pulling info from 3 tables into a cursor using SQL. That works like a dream, but now I'm using that data between 2 forms...I need dynamically set the order of a 3rd cursor according to the order of the 2nd cursor. Is there a way to do this?

I don't want to create an index though, I just want to set the sort order of the resulting cursor...which I do for the second cusor like this

SELECT partno, descript, etc. FROM TMP1 INTO CURSOR TMP2 ORDER BY PARTNO

Where Partno is the field to be ordered by...The reason I'm asking is because I've got a grid, and when they click on the heading it will order the cursor by that column, but what I'm doing there is just reissuing the SELECT statement with another field after ORDER BY, but I've got a details form that comes up and it's based on a 3rd cursor with fields from tmp1 and tmp2...but I'd like to pull the order from TMP2 to set TMP3 with...get my drift?