I have a main Invoice DB, but related to this I have an InvoiceDescriptionsDB. Related by Invoice number

When someone raises an invoice, they may have many parts to the invoice which are created in the InvoiceDescriptionsDB. The InvoiceDB shows all of the descriptions for each invoice within a portal.

How do I show a total amount - for all the parts - on the Invoice DB. At the moment all that happens is that it shows a total for all parts for all invoices.

Thanks

Make a calc field in the Invoice file:

Sum (PortalRelationship::ItemAmount)

Thanks. you have saved my sanity!!!