Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

record cannot be added because it already has a parent record

Posted on by 2,040

So I tried to set up a bidder information custom entity and create a many to many relationship between it and the opportunity and every time I try to add bidder records to the opportunity subgrid, I get this error. anyone seen it before? ideas?

 

thanks,

~brian

*This post is locked for comments

  • Kyle M Garrett Profile Picture
    Kyle M Garrett 315 on at
    RE: record cannot be added because it already has a parent record

    I should add that if I try to delete the mapping, it gives me the following error

    "Could Not Delete Field Map"

    "One or more of the field maps could not be deleted because they are being used by the Microsoft Dynamics CRM platform"

  • Kyle M Garrett Profile Picture
    Kyle M Garrett 315 on at
    RE: record cannot be added because it already has a parent record

    Gus,

    I'm getting this same error when I try to create a NEW Contact from the Account Subgrid (note I've renamed Account to be Household)

    I'm wondering if I accidentally mapped the fields incorrectly at some point? See mappings screenshot below.

    Any thoughts?

  • Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at
    Re: record cannot be added because it already has a parent record

    :)

  • Brian Geraghty Profile Picture
    Brian Geraghty 2,040 on at
    Re: record cannot be added because it already has a parent record

    that's awesome thanks! At the same time I had a colleague show me the N:N thing, which also works and can be hooked into a subgrid so that also gets me where I need to be apart from the import/export problem. so I may end up using your method int he end. Turns out as well that someone else had monkeyed around with the relationship which the subgrid was based on, and hence the whole thing was a problem to begin with.

    thanks again Gus, you always seem to have the answers,

    ~B

  • Verified answer
    Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at
    Re: record cannot be added because it already has a parent record

    Exactly. Instead of creating an N:N relationship between Bids and Opportunities, you create a 1:N from Bids to Opportunities. In other words, a Bid will be linked to a single opportunity (Lookup Field on the Bid Form) and an Opportunity can have severals Bids linked to itself that can be displayed on a grid.

    I tried to connect to our customer to take a screenshot but they have already reassigned my license to someone else.

    Let me know if you need any help.

    Thanks.

  • Brian Geraghty Profile Picture
    Brian Geraghty 2,040 on at
    Re: record cannot be added because it already has a parent record

    so I can just add a grid and a lookup to the custom entity 'bids' I already built and that should do it?

  • Suggested answer
    Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at
    Re: record cannot be added because it already has a parent record

    I guess I'm not sure what you are trying to do. I recently worked on a project where I captured bids for Opportunities so what I did was, I created an Entity called "Bids" and Placed a Lookup (I.E. 1:N) Relationship to the Opportunity and one to the Account along with other fields (I.E. Bid amount, Bid Date, etc).

    Then I placed a grid on the Opportunity form showing the Bid Records and from the Account form you can click on the left navigation link to see the bids that company has participated on.

    My experience has taught me that these type of "Connecting Entities" are way easier to manage than N:N relationships.

    Did I mention that you CAN'T import N:N Relationships but you can import my "custom bid" records anytime? :)

    Maybe something for you to consider...I can send you some screenshots of the solution I implemented if you want.

  • Brian Geraghty Profile Picture
    Brian Geraghty 2,040 on at
    Re: record cannot be added because it already has a parent record

    would you think I would have to do some mappings? or could I just create the N:N relationship? I can go to the bidder and point at different records, but then can't see that from the opportunity subgrid; weird.

  • Suggested answer
    Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at
    Re: record cannot be added because it already has a parent record

    Can you go to the bidder and change the opportunity it is linked to from the bidder form directly?

    This same error happens when you try to add a contact to an account from the account form when the contact has a parent account already.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans