I'm working on a requirement to allow a user to create an Opportunity, add existing Locations (custom entity) record, and fill in the customs fields. But Opportunity-Location requires N:N relationship.
What I did is following the steps from here https://community.dynamics.com/365/b/patchesincrm/posts/how-to-create-manual-many-to-many-relationships-in-crm. I created a manual N:N relationship between Opportunity & Location, with the intersection custom entity "Opportunity Location". "Opportunity Location" has additional customs fields.
Next, I add "Opportunity Locations" subgrid in Opportunity form. However, the resulting buttons in the subgrid are "Add Opportunity Location" and "Add Existing Opportunity Location".
It doesn't allow me to add "Existing Location".
Can anyone suggest / point me to the right direction?