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, 200916 yr by Guest

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

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?