>>>2. In the RelationalExpr you should place just the foreign key (DocType). However, your index on the documents table is DocType + dtos(docdate). The documents well then show in calendar order.
>
>>Have you tried this partial match of indexes
>>(childorder tag expression is doctype+dtos(docdate) and relationalexpr is doctype )? I cannot put partial match to work: child shows record
>>only when childorder and relationalexpr are exactly the same. Maybe set exact of some other setting affects?
>
>Yes, I use it in both VFP3 and VFP5.
>
>1. Your index key on your child table should be DocType+dtos(DocDate) name DocType
>
>2. Set RelationalExpr to DocType (The field in the Parent table that links the two tables)
>
>3. Set ChildOrder to DocType. ChildOrder is the index tag NAME, not the KEY FIELDS.

This works only if set exact is off. Unfortunately, i use
set exact on in all my programs and then this will not work.