record cannot be added because it already has a parent record

(0) Share

Report

Posted on by Brian Geraghty

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

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Gus Gonzalez 27,113 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Brian Geraghty 2,040 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Gus Gonzalez 27,113 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Brian Geraghty 2,040 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Gus Gonzalez 27,113 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Brian Geraghty 2,040 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Gus Gonzalez 27,113 on at

Like (0)

Report

:)

Was this reply helpful? Yes No
Kyle M Garrett 315 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Kyle M Garrett 315 on at

Like (0)

Report

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"

Was this reply helpful? Yes No