Dynamics online.
I have an entity called engagements for our customer engagements.
This has fields for customer name (lookup), engagement name, and many others.
I have a entity called Service Locations. Many customers may have different locations we provide service at.
There are fields like customer name (lookup)
So an engagement can take place at one location or may take place at several locations.
When I created a subgrid to put on the engagement form for service locations, it gives me the option to add new or add existing.
If I click add existing, it shows all Service locations no matter what customer.
I would like to only show Service locations for the particular customer on the engagement form.
From research the community I found a couple that suggested creating a "middle entity"
Based on those I created a new entity called Engagement Locations
With these fields:
Name (primary)
Customer (Lookup)
Engagement Name (Lookup)
Location (Lookup)
I also created or editing N:1 mappings on the Engagement Location Entity.
To Engagements - Linked Customer names and Engagement Names
To Service Locations - Linked Customer Names and Locations
I published everything
I then added a new subgrid to the new middle entity.
It only gives me the option to add new, not add existing. And when I select add new and fill it in, when I get to the locations field, it shows me all locations, not locations only for that customer.
So I think I am doing something wrong? Maybe created wrong relationship, or mapped wrong fields, or made wrong things required vs optional...
From my description is there anything anyone notices? Or is there a better way?
I wont.. haven't had time to go back to yet, other fires.
Terry
Hi partner,
Please don't forget to close this theme by clicking Yes to mark the verified answer.
This will help other users quickly navigate to this theme.
Thanks. :)
Hi partner,
In the form editor, open the set properties of this sub-grid and check if its Data Source is All Record Types.
If so, then this is the reason for this issue.
You should choose Only Related Records instead of All Record Types.
Then select the Entity. The parenthesis after the entity name is the display name of the lookup field of the 1:N relationship. You could select the correct entity based on this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156