Related Portal with Related Repeating Records?

[clippermedia]

I'm building a small invoice system.

I have 4 databases for client information, product description, delibery invoice and "final invoice". There are some relationships between them who allows me to include new related related records like "line items" in one portal in the delivery invoice. Now I need to show the related delivery invoices of any client in the final invoice, based on a value list obtained from the delivery invoices IDs, but I can show only the first related record of one client.

In other words I need to show in the final portal related records from the delivery invoices including the "line items" of each referenced item. Example, show a portal with 2 delivery invoices, one with 10 products and one with 5 without spaces between them to print the final invoice of each client. I need to show invoice numbers like related records in one column and product items of the related invoice in another column.

And another question: How can I number the related items in the final portal? I was trying with "Status (CurrentLineItem)".

Thank you

[LiveOak]

There is no way to display a portal within a portal. If you think about your process, you probably don't need a display with quite this amount of gagetry. It might adequate to click on a line item and have another portal show the delivery notices for that line item. In your basic portal row it is probably adequate to know if there is a least one deliver for an item. If so, you can then click on a button in the portal row to display the list of delivery notices for that row in another portal. Just an idea. I would stay away from repeating fields. They have the limitations of displaying only a fixed number of notices and requiring a scirpt to update the entries.

-bd