2 Replies Latest reply on Sep 29, 2011 2:38 AM by creek

    Portal and Relationship

    creek

      Title

      Portal and Relationship

      Post

      I have defined the relationship between two tables ( Table1 and Table2 ). I want to display values, from two tables in one portal. (Portal is in Layout Tab2). In the column value2 I see constantly the same values, unfortunately. I can not deal with this problem. Please help me.

       

      Copy database in the attachment.
      http://www.4shared.com/file/cHL1ci_0/PortalAndRelations.html

        • 1. Re: Portal and Relationship
          Sorbsbuster

          The problem is that the layout is based on table 2, the portal is based on the relationship Table2 -> SelfByConstant, but the field you are talking about is from the TO called Table 1.

          You need to create a downstream TO based on Table 1, and relate it by the keys you mean (I think that would be FK to PK) from the Table 2 Self Relationship TO.

          In other words, create a new TO called Tab2 Self To Tab1

          Relate it by:

          Tab2 Self::FKID = Tab2 Self To Tab1:;PKID

          and it shows the correct data for all of the Table 1 records.  I assume that was what you intended.

          • 2. Re: Portal and Relationship
            creek

            Sorry for the late reply.


            Thank you very much. Really helped me. :)