3 Replies Latest reply on Mar 4, 2011 10:33 AM by philmodjunk

    Display both child and grandchild fields by one portal

    RedL

      Title

      Display both child and grandchild fields by one portal

      Post

      We have parent table, child table, and grandchild table.  Grandchild table is linked to child table while child table is linked to parent table.

      We have portal for child table which is sit inside parent table layout.  It works pretty good.  Can we have some grandchild fields on the same portal also?

        • 1. Re: Display both child and grandchild fields by one portal
          RonCates

          In a portal showing child records the portal displays one child per row. If you have multiple grandchild records from the child adding a grandchild field to the portal in the parent will only display data from one grandchild record which will be the first.

          • 2. Re: Display both child and grandchild fields by one portal
            RedL

            I think my question is not clear.  Here is our solution.

            On the Invoice layout, which is invoice table, we have PaymentDetail portal row.  It works.  And on each PaymentDetail portal row, we would like to include Payment table fields also. For example PaymentDate field which is on Payment table only.  The relationship is below.
            Invoice::_pk_Invoice_Key link to PaymentDetail::_fk_Invoice_Key (Each Payment might pay to multiple invoices.  Each PaymentDetail links to one invoice.)
            PaymentDetail::_fk_Payment_Key link to Payment::_pk_Payment_Key (Each payment might have multiple PaymentDetail.)

            • 3. Re: Display both child and grandchild fields by one portal
              philmodjunk

              As Ron posted, you can indeed include fields from Payment in a portal to Payment detail. Since there is only one related record, his warning does not apply. You'll be able to display data from payment and edit also if you want. What you won't be able to do without additional design work is to use a field to Payment in this portal to create a new Payment record.