Viewing multiple relationships

[PaulR]

Is it possible to view more than two related tables at the same time? For example, if I have the following set up:

Customers -> 1 to many -> Orders
Orders -> 1 to many -> Order Items

I'd like to be able to see customers, associated orders and items for each order (as it is selected) in the same view. I have this set up and working correctly but when I 'drill down' to order items the related customer record is no longer visible. The view I'd like to achieve is something like this, where items are being shown for Mr Smith's order 23876 (I added square brackets just to show which records were 'current').

Code: Select all

Customer   Order       Items
[Mr Smith]   12345      Widget 7
             17865        Part 42
             [23876]      Item #19
             27890
               


TIA

Paul

[shannah]

You'll either need to create a custom action for this, or add a section to the view tab using the section__sectionname() method in the parent table's delegate class containing the output you want.

-Steve

[PaulR]

Thanks Steve at least I know where to start now!