using a table with a many-to-many relationship

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!!!

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

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/supercharge-your-ui/l/269735-add-nested-rows-to-your-table-with-drawers

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.

  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”

Thanks so much!!! That worked for me. I am still a newbie.

Your help is greatly appreciated as always