View records that does not has direct relationship between entities

(0) Share

Report

Posted on by AM-22040756-1

407

I have an entity named Programs, each Program has multiple Proposals. So there is a subgrid of all the Proposals in the Program form. Each Proposal has multiple Contacts associated with the Proposal, and each Contact can be associated with multiple Proposals. So there is an N:N relationship between Proposals & Contacts. There is a subgrid of all the associated Contacts in the Proposals entity and there is a subgrid of all Proposals that each Contact is associated with in the Contact entity. There is no direct relationship between these Contacts and the entity Program, but I want to show a subgrid of all the Programs that each Contact is associated with in the Contact form. I know there is no OOB way of doing this, so what is the best possible way to achieve this?

I have the same question (0)