can you have a portal within a portal

by this i mean i have company database within which i want to show their orders (which is fine) done in a portal i can show all of their orders. BUT each order has a list of order items stored in a file related to the order file.

in the order file i have a a portal showing a list of all the items in the order (great)

i basically want to show the list of order items in the company file

is it possible and has any of this made sense

the relational scheme goes

company----<orders -----<items

[ April 09, 2002, 07:48 AM: Message edited by: thewalker ]

Hi,

If you have a global field called _gorderlines (same type as your order id field.

Create a relationship from this to the line items database relating to the order id.

Then script your order portal to Set field [_gOrderLines], to the order portal relationship::orderid]

Basically, you look at a company and see all their orders.

Then, when you click on an order it sets the global field to the order id. This is used in a relatioship that will show all lines for that order.

HTH