>I am still having trouble sorting the detail items on a one-to-many report. The only suggestion given a few weeks ago when I posted the question was to set the order of the cursor in the dataenvironment, which I have done. It doesn't do a darn thing. Has anybody actually tried this and it works? If not, how do I do this? As seems to be par for the course in learning VFP features and quirks, the documentation is of no help. I must find a way to do this, please help. Thanks
>
>Erik
Erik,
The first hing you need is an index that will both support hte relationship and give you the order you want. Let's assume the table is name dChild and its key for the relatioship is a field named ParentId (Character) and you want the recor din order by the EntryDate field (Date), you need an index like this one;
USE Child
INDEX ON ParentId + DTOS(EntryDate) TAG ReportOrder
Now set the order for the table, in the report's DE to ReportOrder and set the realtionship from Parent to Child and set the OneToMany property to .T.