AnsweredAssumed Answered

Sort Order of related tables

Question asked by brendenmaher on Nov 8, 2010

Title

Sort Order of related tables

Post

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)-- 

Transportation:                                 

Plane 1                             

Cars 3                            

Boats 2                           

Cars:   

Ford   3

Honda  1

Chevy  2            

CarModel:

Bronco     1  

Focus      3

F-150      2

Odessy     1

Accord     3

CR-V       2  

Silverado  2    

Malibu     1

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??

Odessy 

CR-V

Accord 

Malibu
Silverado

Bronco

F-150

Focus 

Thanks. b.

Outcomes