>>Hi,
>>
>>If I have the following records in a table.
>>

SID Desc  PID   LX
>>1....A....0....0
>>3....B....1....1
>>5....C....3....2
>>7....D....5....3
>>8....E....14...3
>>14...F....3....2
>>21...G....3....2
>>22...H....21...3

>>
>>and I want to sort so the table looks like a tree structure
>>
>>

SID Desc  PID   LX
>>1....A....0....0
>>3....B....1....1
>>5....C....3....2
>>7....D....5....3
>>14...F....3....2
>>8....E....14...3
>>21...G....3....2
>>22...H....21...3

>>
>>SID - Structure ID
>>PID - Parent ID
>>LX - Level in the tree
>>
>>Could this be done using a select statement? Any help or suggestion is appreciated.
>>
>>Thanks
>SELECT * FROM sometable ORDER BY sid

Or, in case there are some repeats in the other fields,

SELECT Sid, Desc, Pid, Lx ;
  FROM MyTable ;
  INTO CURSOR MyCursor ;
  ORDER BY Sid, Desc, Pid, Lx

Matthew - be sure to re-arrange the field names and ordering, and to test with enough repeating fields to get what you want.