Display Related Records in Detail View

Collapse
X
Collapse
+ More Options
Posts
 
  • Time
  • Show
Clear All
new posts
  • Stefan
    Member
    • Jul 2021
    • 57

    Display Related Records in Detail View

    Hi guys!

    Following initial situation:
    Entity A 1:n Entity B

    Is it possible to display all other B related to A in detail view of B?

    I tried it with reportpanel, but unfortunately that didn't work.​
  • shalmaxb
    Senior Member
    • Mar 2015
    • 1611

    #2
    The relationships creates field for both sides, which you the may use to display, for example all record of B, that are related to A and vice versa. Possible with default tools.

    Comment

    • Stefan
      Member
      • Jul 2021
      • 57

      #3
      @shalmaxb​: Thanks for your answer!

      But the relationship is betwenn A and B, and not B and B. Or am I missing something?

      And i want to display all B (with same A) in B. (I hope that is understandable).

      Comment

      • shalmaxb
        Senior Member
        • Mar 2015
        • 1611

        #4
        you can create whatever relationship you want, between A and B (which is automatically also between B and A), between B and B or A and A. Who never worked with relationships before needs to experiment and learn a bit. But once you get it, it is a marvellous functionality in espoCRM.

        Comment

        • Stefan
          Member
          • Jul 2021
          • 57

          #5
          I think we're talking past each other a little. I am well aware of how relationships work.

          As written, I have a 1:n relationship between A and B.

          So for example:
          A1 -- B1
          A1 -- B2
          A1 -- B3
          A2 -- B4

          Now the question is whether I can display the other Bs related to A1 (B2, B3) in B1 without creating a separate relationship between Bs, as there is actually already a relationship via A1.​
          Last edited by Stefan; 10-09-2024, 11:48 AM.

          Comment

          • shalmaxb
            Senior Member
            • Mar 2015
            • 1611

            #6
            ok, I see. I think, this is not possible with espoCRM alone. I have this kind of relationship, which involves a middle entity realised with the extension Link Multiple by Eblasoft (excellent extnsion by the way). With that extension it is possible to create a middle entity and connect entity A with B1, B2 and so forth.

            Comment

            • Stefan
              Member
              • Jul 2021
              • 57

              #7
              I was actually hoping that this would work with the Advanced Pack and the ReportPanels ...

              I also have Link Multiple by Eblasoft. However, as far as I know, I would have to create a new middle entity for this and could not use the existing relationships. Right?​

              Comment

              • shalmaxb
                Senior Member
                • Mar 2015
                • 1611

                #8
                you can read here how it works: https://www.eblasoft.com.tr/post/lin...o-many-to-many

                Comment

                • Stefan
                  Member
                  • Jul 2021
                  • 57

                  #9
                  Thank you for your input shalmaxb, but I think that's is not a suitable solution to my problem.

                  If anyone has a solution to my problem I would be very grateful.

                  Comment

                  Working...