Sort Order of related tables
Hi I have have multiple tables in a hierarchical 1 to many relationship which I want to export sorted.
The way I understand it "sort order" is only applied to the table bound to a layout??
I have Three tables- Transportation, Cars and CarModel and I have a field in each table called ViewOrder which is a number for ordering the rows in each table. These tables are hierarchical so I want to view then export an ordered tree. For example if the data in the tables were: (where the numbers are the view order for each table)--
So I wanted to export Transportion = Cars and all the related records in the other tables
in such a way that the prior table in the hierarchy an it;s ViewOrder influences the final sort ! Help??