It ain't pretty, but I think this works. You'll need to add housekeeping code.

* Test is the table you described

select *, recno() as rec from test into cursor t1 nofilter
index on grp_name to t1 unique

copy to t2

select t2.grp_name, t2.rec, test.subseq ;
from t2, test ;
where t2.grp_name = test.grp_name ;
order by rec


>Good idea, except that the groups can be anything. They come from a table that can be added to on the fly. I will never no what order the items appear in. Maybe if i use the grouper UDF and build an array as I pass the name in....
>
>Thanks for the idea..
>
>>

>>Don't you just need an ordering field based on Grp_Name?
>>SELECT Grouper(grp_name) AS Grouper, etc. ORDER BY Grouper, Subseq
>>where
>>Grouper is a UDF
>>FUNCTION Grouper
>>LPARAMETER GrpName
>>DO CASE
>>CASE m.GrpName = "input"
>>   RETURN "01"
>>CASE m.GrpName = "cables"
>>   RETURN "02"
>>MORE
>>
>>ENDCASE
>>Charlie
>>
>>>I have a table that contains numerous fields among which are<BR> grp_name and subseq in the following order:
>>>
>>>grp_name     subseq
>>>input          1
>>>cables         2
>>>education      3
>>>cables         4
>>>education      5
>>>cables         6
>>>input          7
>>>
>>>The problem I'm having is that the resulting cursor from the select <BR>must be ordered by grp_name (not alpahbetically but in the order they <BR>appear) and then by subseq in order ie:
>>>
>>>grp_name     subseq
>>>input          1
>>>input          7
>>>cables         2
>>>cables         4
>>>cables         6
>>>education      3
>>>education      5
>>>
>>>I have tried various combinations of Group By and Order By to no <BR>avail.  Any ideas?
>>>
>>>