Viewing multiple relationships

Archived from the Xataface Users forum.

PaulR — Fri May 25, 2012 12:56 am

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 — Mon May 28, 2012 12:10 pm

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 — Tue May 29, 2012 12:43 am

Thanks Steve at least I know where to start now!