Skip to main content

Notifications

Microsoft Dynamics CRM forum
Suggested answer

The record cannot be deleted because it is associated with another record.

Posted on by 145

Hello,

I have some product bundles that I had to clone in order to be able to remove old products and add new ones to them. However now that I have added the new products, I'm trying to delete the old ones but it won't let me and gives the above error. I understand that it's saying it's associated to something, but it won't tell me what it is. This wouldn't really be a problem except that there's a powerapp used for selling stuff that pulls from the CRM the products. But that powerapp is showing the retired product bundles as well as the new ones and it's making it very messy. \

What do I do? The 2022 bundles/products are the ones I made, but as you can see, the list is long and confusing with all the old stuff still showing up.

pastedimage1669298906946v1.png

Categories:
  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Moderator on at
    RE: The record cannot be deleted because it is associated with another record.

    Hi XeXE,

    As I told you in my last reply. Deactivate all the products you do not want to appear in control. The control must be associated with the query or the view. Add filter(s) in the 'view' or in the 'query' so that the control stops showing these records to you. 

  • XeXE Profile Picture
    XeXE 145 on at
    RE: The record cannot be deleted because it is associated with another record.

    Hi. This didn't work, is there any way of at least turning these bundles and products off so that the powerapp won't see them?

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: The record cannot be deleted because it is associated with another record.

    Hi,

    Please check relationship behaviour by going to maker portal

    learn.microsoft.com/.../data-platform-entity-lookup

    You will need to check the Restrict Delete type for parental relationship

  • XeXE Profile Picture
    XeXE 145 on at
    RE: The record cannot be deleted because it is associated with another record.

    I have no idea what you mean. I need the old bundles/products to not show in the powerapp. I was able to delete some that I had created for testing and they disappeared from the Powerapp. But some of them refuse to be deleted giving the error that they're associated with something else and others I retired, but they're still showing up.

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Moderator on at
    RE: The record cannot be deleted because it is associated with another record.

    Hi XeXE,

    I think you might need to filter the view associated with this control instead of deleting old records. What do you think?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans