>Hi to all,
>I have a report that displays data from 2 tables.
>The child table holds among other information a field that holds a number (1,2,3,4,5, etc..) denoting the printing sequence.
>The use for this is to sort the records in the number's physical order
>I tried to do this in the data environment by 'ordering the data' by this field but no cigar.
>Any ideas?
>Thanks in advance.
>Mike

Mike,
the simplest way to do this is to run a SQL into a cursor that holds only the fields you want to report on from both tables. You can then order that cursor any way you want. If your not comfortable with SQL I suggest you learn it becuase it is by far the best way do do this stuff. It sounds like this one should be easy to do.