Nested Portals

[mikemurry]

From what I have read on these forums, it's evident you can't have specific nested portals. But I have not yet found a solution to my problem.

I have three files: Customers, Invoices, and Products. Customers has all the contact information and orderID, invoices simply has the orderID, productID, and quantity. Products has productID and the product name.

In my customers file, I have a layout that presents the customer information and a portal to the invoices file to show the quantity and productid of the orders. What I want is for the portal to also match the productID with the product name from the products file. That way you get the actual product name instead of a number.

Thanks for any suggestions!

Michael

[kennedy]

In Invoices, add a calculation field ProductName that is computed as PRODUCT::Name, where PRODUCT is a relationship from Invoices to Products keyed on productID and Name is the name of the product in the Products file.

Then you can use ProductName in the portal in your Customers file.

[mikemurry]

That did it! Thanks!