web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Manual many-to-many relationship subgrid

(0) ShareShare
ReportReport
Posted on by 5

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?

I have the same question (0)
  • meelamri Profile Picture
    13,216 User Group Leader on at

    Hi Jim,

    Could you please share some screenshots?

  • Suggested answer
    dian74 Profile Picture
    2,477 Most Valuable Professional on at

    You should have 3 tables: 

    Opportunity
    Location
    Opportunity Location

    On the opportunity location table you should have a lookup to the 'opportunity' table and to the 'location' table (and any additional fields you want to track). You can then create a new 'Opportunity Location' record where you tie a location (lookup) to an opportunity(lookup). This is the manual N:N. You cannot tie an existing Opportunity Location record to an opportunity because the relationship between 'Opportunity' and 'Opportunity Location' is 1:N. You build a manual N:N relationship between 'Opportunity" and "Location'.

    Please mark as verified if helpful

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 74 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 31 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans