What's the best way to display multiple related tables on a single layout?

[angelleye]

I'm a little bit confused on how to display a bunch of related data on a single layout. I'm using to portals to display lists of related easily enough, but what if I want to display form details of a related record (or multiple related records) on 1 layout?

Here are the tables/relationships I'm working with...

As you can see we have an orders table and an order items table. Pretty straight forward there. Each order item, though, can have multiple "sides" added to it so there's a related table for those. And then each side can have multiple "side options" added to them so there's another related table for that.

So, I've got a page setup where I'm viewing order details and I'm trying to get all of the order items (and their sides/side options) to show up nicely on this 1 page. I can't seem to figure it out. Here's a screenshot of the order layout...

So you can see I'm using a portal to display the related order items easily enough, but now what about the options related to each individual order item? I don't want to have to click away from this layout to another "item details" layout. When I get there I'll just need yet another one for "side item details".

Is there some simple way to just show all of this data on the original order layout I showed above?

Any information would be greatly appreciated. Thanks!

[Inky Phil]

Hi Drew,

Have a look at tabs. They are the only way that you are going to fit more and more levels of detail into what seems to be an already quite full layout.

HTH

Phil