AnsweredAssumed Answered

How to get Information from 2 related tables in one portal

Question asked by daveslc on Jan 25, 2012
Latest reply on Jan 26, 2012 by Sorbsbuster

Title

How to get Information from 2 related tables in one portal

Post

Hi,

I have 3 tables:

Projects

Invoices

Items

 

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) 

and

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?

thanks,
Dave

 

Outcomes