>I have a one to many form with two tables. The parent, HEADER, and the child, DETAIL. The two tables share a common field, QUOTE_NO. I can get the report to run, showing all of the detail lines for each header, but I can't sort the detail. I have an index tag (SIZE) that indexes on two fields, DENSITY+THICKNESS. It works fine when doing a browse, but won't work in my form.
>
>I've messed around with ChildOrder and Order, but most of the time I lose my detail lines. What am I doing wrong?
John,
Create an index on the child table wiht the key of;
PADL(Transform(Quote_no),20) + Density + Thickness
set your child order to this index.