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
May all your weeds be wildflowers