1 Reply Latest reply on Jan 26, 2012 12:14 AM by Sorbsbuster

    How to get Information from 2 related tables in one portal

    daveslc

      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