Hello Trailblazers,
I have a custom object called order requests. I have a process/use case where an order request record is created first and then an opportunity record is created via process automation. There is a lookup relationship from order request to opportunity. So on the order request record I have a related list of opportunities.
For internal auditing purposes I have been asked to have a related list on the opportunity that shows order requests. I don't think this can work as the relationship is the other way around.
Is there any way to show a related list of order requests on the opportunity in this scenario?
Thanks Trailblazers
Forum Ambassador Eric Praud (Activ8 Solar Energies)
Don't apologise! Let us know how you get on.
One thing I forgot to add, solution 2 seems like the best to me. You can also add formula fields to the junction object to get info from Opps and Order Requests and you can show those in the related lists. Since both related lists woudl be on different objects, you can show the Order requests formual fields when on the Opp page, and the Opp formula field when on the Order request page.