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 :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Can't remove related record from subgrid - only delete

(0) ShareShare
ReportReport
Posted on by
I have a requirement to relate multiple Contact records to an Agreement record.
 
From the Agreement, I created a 1:N referential relationship, then added a subgrid to the Agreement form to allow adding/viewing the related records.
 
However, I only get the option to Delete the related record (which deletes the entire record from the system). Instead, I only want to remove the contact record from the subgrid and not delete the record. 
 
Can this be achieved? I'm new to creating relationships between tables, so I feel it may be something I'm missing here.
I have the same question (0)
  • Suggested answer
    Leah Ju Profile Picture
    Microsoft Employee on at
    Hi Partner,
    When you create a 1:N referential relationship, one agreement lookup field will be created on contacts entity.
    These contacts appearing in the sub-grid are related to the current agreement by the lookup field.
    If you want to remove contacts from the sub-grid but not delete them, you need clear agreement lookup field, but no OOB button can help you achieve it directly.
    --You can click one contact to edit it, clear the field on the form.
    --If you don't want to edit it manually, you can create one on-demand workflow on contact entity.
    Test:

    I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
    Regards,
    Leah

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 > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 45 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 27 Most Valuable Professional

#3
Soundari Profile Picture

Soundari 15

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans