If it is in the child table, you may want to try addressing it directly
ie childtable.EFFDATE

Try opening the table in question and type
index on PRSCHED+CODE+STR({^3000/01/01}-EFFDATE) TAG x
see if it can do it from the command line or if there is a problem with the expression.

I would think you would have to open the child table first and set a relation for it to work.
Try also going into the dataenvironment and onto that table, and give it no default index.


>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