Use Case:

I have a custom object that I've created, that can look up to the Salesforce standard object Product, up to 12 times. Because of the field structure of doing that, it has created 12 separate Related Lists.

Is there any way I can condense all these related lists into 1? A pivot related list, so to speak...

  • Is there a reason you're not using a join object? Your data model has multiple issues (as you are seeing) and is not scalable. – David Cheng May 27 '20 at 20:15
  • How would you use a join object in this case? – Dan Watkoski May 29 '20 at 13:34
  • @DavidCheng, also, what are the other issues? I want to get better at this! This issue I have posted isn't even an "issue" yet. I just want to get ahead of it – Dan Watkoski Jun 2 '20 at 12:49
  • I think based on that video, this would be considered a junction object. I would still like to talk more about other issues I am having, and if you have an idea of how to perhaps shore up this idea, if you have some time. – Dan Watkoski Jun 8 '20 at 13:35

You can query them all and display them on the custom component using the lightning data table.

Aura Datatable | Lwc Datatable

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.