Yep! And you've gone beyond me. But if what you end up with works well, it sounds really useful, and I would love to see it show up in the files section here. Hope that someone else will have better help.

(altho, if I were in your position I would either make a custom class to handle the SQL for me, or I would try to get the information I need with cursorgetprop or dbgetprop (check them out in help))

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