using VFP 7

I have 2 files with a 1 to many relation in record_id

Ie

File 1

Record_id field1 field2 ….
1 aaa bbb
2 dfg sdfg


File2

Record_id,field_1,field_2 …. Recno()
1, xfg, 00001, ... ,1
1, 2134, 00002 ... , 2
1, sdfads, 00003 ... , 3
2, retre, 00001 ... , 4
2, fdsga, 00002 ... , 5

I created a 1 to many report with the report wizard.

The result is in reversed order on the detail

ie

Record ID: 1
Field1: aaa field2: bbb

Field_1 Field_2
Sdfads 00003
2134 00002
xfg 00001


the order set on both files is record_id

So why I get reversed order (recno() wise) on the result print out?


Thanks.
BDH