Yes effdate is a date field in the child table

the key expression is PRSCHED+CODE+STR({^3000/01/01}-EFFDATE)

hence the

SET ORDER TO 1 && "PRSCHED+CODE+STR({^3000/01/01}-EFFDATE)"

{^3000/01/01}-EFFDATE gives me reverse date order.

regards
Geoff Scott