>I'm using an integer primary key and wonder how I can get the child data in a grid to be sorted in an order other than the foreign key used to relate to the parent.
>many thanks
>Jeff
The only way I can think of is to convert your indices to alphas and concatenate the necessary indices with your foreign key:

USE myParent
* - fKey1 = STR(key,10) + cfield1, fKey2 = STR(key,10) + STR(nfield2,10), etc         
USE myChild ORDER fKey1 IN 0
SET RELA TO STR(key,10) INTO myChild   && child ordered by character field
SET RELA TO
SET ORDER TO fKey2 IN myChild
SET RELA TO STR(key,10) INTO myChild   && child ordered by numeric field

HTH