>My relations break when attempting to create a report with order set to Line-Item field.
>I have a one2many Ship Parent to ShipSub Child on ShipT field.
>
>How would you generate a report with that relation holding and rearrange the Child table band records in an order by line-item# ?
>
>I tried creating a View with the ShipSub line-item order and attempted to relate that to the Ship table === it don't like that.
>
>Any help is appreciated VFP3
>Ed B
Edgar,
If OneToMany = .t. (set skip to) then extend your ShipT index key in child to order by line_item#
index on ShipT+padl(Line_ItemNo,6,'0') tag myRel
Cetin