>>>>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.
I see. Why do you have set exact ON? I usually use the '==' terminology when I need an exact match, and leave set exact to OFF.
Barbara