5 Replies Latest reply on Apr 9, 2012 2:45 PM by Stephen Huston

    Grandchild records and portals

    mcgeo52

      I have a database with four tables, one of which is not relevant to this conversation.

       

      A is the parent.

      B is the child.

      C is the child of B and grandchild of A.

       

      I need a protal on a layout of A populated with records from C.

       

      B is basically a join table so the tables are related thusly:

      • A has key aID related to key aID in B
      • B has key cID realted to key cID in C

       

      Is this possible? If so how? I have tried, but if it is possible I am apparently putting the wrong key or filed in my portal.