Data sorting

[NewFM85User]

Hi,

I have a customer table and products table. A product can be ordered jointly by 2 customers where one will be primary and the other is the secondary.

Here is my issue. I am creating a table occurance TO1 by joining ralated product table and few other billing tables .One of these table has the primary flag is the table which I am using to sort the records. This TO1 has the records sorted by Primary flag. I create one more table occurance TO2 by joining TO1 which has the primary flag to be sorted and the customer table(this does not have a primary flag). When I am retrieving the data from TO2, I want the primary customer to show up first. On few layouts I just show one agent which is the primary. But for some reason, my TO2 does not retrieve the data in sorted by primary flag; it always shows by First name sorted from the customer table. What I am doing wrong? Or what do I need to do to get records in TO2 sorted by certain field. Please advice.

Thanks.

Edited August 21, 2009 by Guest

[bcooney]

Sounds like your script needs the Sort script step. A table doesn't "remain" sorted for a report.

[NewFM85User]

Attached is the relation graph. Looks like grand child sorting is not picking up child sorting, but picks up parent sort as you explained. Any work arounds?