0 Replies Latest reply on Nov 8, 2010 1:14 PM by brendenmaher

    Sort Order of related tables

    brendenmaher

      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.