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!!!
Question
using a table with a many-to-many relationship
This topic has been closed for replies.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.