using a table with a many-to-many relationship

  • 1
  • Question
  • Updated 3 years ago
  • Answered
  • (Edited)
I have a many to many relationship between two objects with bridge object.

A -> B <- C

I've created a table, with object B as my source. I want to display the name from object A, and the attachment Id, from object C.

However, for every Id in object C, I will get a new line item repeating the name in object A.

The question is, I would like one line item for each name in object A, with a way either of expanding the line or hover-over, to show the associated Ids in object C. Does anyone know how to go about doing that?

To help visualize...

Currently the table is like...

- ObjectA.Name1   |   ObjectC.AttachmentId1
- ObjectA.Name1   |   ObjectC.AttachmentId2
- ObjectA.Name1   |   ObjectC.AttachmentId3
- ObjectA.Name2   |   ObjectC.AttachmentId1
- ObjectA.Name2   |   ObjectC.AttachmentId2
- ObjectA.Name2   |   ObjectC.AttachmentId3
- ObjectA.Name3   |   ObjectC.AttachmentId1
- ObjectA.Name3   |   ObjectC.AttachmentId2
- ObjectA.Name3   |   ObjectC.AttachmentId3

I would like it to expand and collapse like...

+ObjectA.Name1   |  ObjectC.Attachment1
                                   |  ObjectC.Attachment2
                                   |  ObjectC.Attachment3
- ObjectA.Name2   |
- ObjectA.Name3   |

Thanks!!!
Photo of Sean

Sean

  • 630 Points 500 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Sean,

Create a model on Object A and add a Child Relationship field to your junction object.  You can then display every attachment id for each Object A in one column.

Thanks,

Bill
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
Bill's solution should work or for something more dynamic you could use a drawer to display your Attachement Id's, but you would have to open the drawer of each row to see the attachments.
http://help.skuidify.com/m/supercharg...
Photo of Sean

Sean

  • 630 Points 500 badge 2x thumb
I've been struggling to implement the two suggestions above. Since it is a many-to-many relationship, both object A and C are parents of object B. Does that prevent me from pulling items from object C, if Object A is the source for my table?

Bill and Raymond, I appreciate the time and assistance on this one.
(Edited)
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
1) When you are setting up object B in Salesforce, you can create a formula field and set it equal to a field from the parent C. That has the effect of putting fields from C in B so that you can display them from A. (Hope that makes sense.
2) for bill's suggestion, you would need to use the child relationship field options in Skuid from a model based on A after completing step 1 above.
3) if you want to do a drawer as I suggested, you would use two separate models instead of using the child relationship fields. You would make the table based on A. Add a row action of drawer. In the drawer, add another table linked to a model on object B after having completed step 1 above.
You can find tutorials by googling "Skuid drawer", "Skuid child relationship", and/or "Salesforce junction object"
Photo of Sean

Sean

  • 630 Points 500 badge 2x thumb
Thanks so much!!! That worked for me. I am still a newbie.

Your help is greatly appreciated as always