How to get Information from 2 related tables in one portal
I have 3 tables:
Projects and Invoices use an id_project key
Invoices and items use an id_invoice key
to relate to each other.
On the Projects layout, I need to show both the invoice related to that Project (which I've done via a portal)
All of the items related to that project (which I've also done via a portal).
But, in the items portal, I need to have the name of the contact associated with the invoice show up on each item row so that I can see all of the items and who is purchasing each one for a particular project.
So, in the portal for items, I need:
Item::Item Name Invoice::Contact Name
I tried adding the Invoice::Contact Name field in the portal row, but that only showed the name of the first invoice related to the project, and not the name related to any of other invoices.
Any thoughts on how to do this?