Issues with re-calculating table order
Circular references within Tables caused the tables to be out of a known proper order per the Client.
The problem is that due to known circular references in the tables, the program simply defaulted to a specific order. There was a 50/50 chance of getting the order right. It was wrong. However, the backend tables can be changed. The following SQL gets you to the table so you can then review it and change the table rto_seq_no for the 2 tables in question.
SELECT * FROM
dbo.gtrep_table_order where rto_proj_id = 2346 and rto_pv_id=2360 order by rto_seq_no