Skip to main content

Notifications

Announcements

No record found.

Customer Service forum
Suggested answer

Adding system view to Subgrid not displaying Add Existing Records button

Posted on by 459

Hi 

i am working on the following requirement.

An Organization can be created as an Association (by setting the relationship field value to Association) (refer to image 1). Then another organization can add association members from the organization list which were created as Association. 

To add association organization to the new organization from the Existing Association Org list:

I created a system view with the Association organization (filtered with organizations where Relationship = "Association"). Then created a Subgrid and selected the System view to the Subgrid  (image 2). However, when i create a new organization,  i wasn't able to select an associate Organization from the Subgrid (refer to image 3). Instead, the Subgrid displays all the Association organizations  (refer to image 3).

How I can enable the "Add Existing Association" button to select from the System View.

image 1

pastedimage1631821418981v4.png

image 2

pastedimage1631821703346v6.png

image 3

pastedimage1631821580679v5.png

Categories:
  • Suggested answer
    Nya Profile Picture
    Nya 29,054 on at
    RE: Adding system view to Subgrid not displaying Add Existing Records button

    Hi,

    The reason why the "Add Existing XXX" button is not shown is that the Field Requirement property of the lookup field is "Business Required".

    For example, I create a custom entity, which has an N: 1 relationship with Contact entity on the lookup field "Contact".

    The sub-grid of Custom entity is added to the main form of Contact entity.

    When the field is "Optional" or "Business Recommended",

    pastedimage1631858121512v1.png

    the "Add Existing Custom" button will be shown.

    pastedimage1631858202039v2.png

    When it is "Business Required",

    pastedimage1631858232868v3.png

    the "Add Existing Custom" button will not be shown.

    pastedimage1631858247327v4.png

    It' s quite understandable that with the "Business Required" design, when a Custom record is created, there is already a corresponding Contact, so it already exists in the sub-grid of this Contact by default and cannot be added to another Contact sub-grid.

    The same is applicable to the entities in your issue.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans