Microsoft Dynamics 365 | Integration, Dataverse...

Many-to-many relationship

(0) Share

Report

Posted on by mithun_m

Hello,

Scenario: I'm building a vendor management model driven application. I have used the Contact entity to for Freelancers and created a custom entity named Certifications.

The certifications entity contains all the MS certifications available. One freelancer can have multiple certifications associated with him or her and hence I have created a many-to-many relationship between Contacts and Certifications as show in the Fig-1.

Issue: After creating the relationship I have added the Certification subgrid in the Freelancers(Contact) form which shows me all the certifications associated with that a specific freelancer as show in Fig-2.

I'm unable to do that same in the Certifications form. I don't see the all the freelancers associated with a specific certification (Fig-3)

Please help.

All responses (9)

Answers (0)

Suggested answer

Nya 29,058 on at

Like (0)

Report

RE: Many-to-many relationship

Hi,

As what are shown in your screenshot, the settings of the sub-grids should meet your requirements.

All you need to do is to tick the Show related records option so that only related records can be displayed.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya
mithun_m 15 on at

Like (0)

Report
RE: Many-to-many relationship

Hi,

The forms I have are:

Contact (Freelancer )

Certification

I have created only one relationship.

Contact Form:

Certifications Form:

I'm unable to figure out the solution.

This is my requirement:

If I click on a specific certification then I should be able to see all the Freelancers (Contacts) associated with that certification

If I click on a specific Freelancer (Contact), that I should be able to see all the certifications associated with that Freelancer(Contact)

I have renamed that Contact entity as Freelancers and created a new entity called Certifications. I have established a many-to-many relationship between the two entities.

Can you please guide further?
Suggested answer

Wahaj Rashid 11,319 on at

Like (0)

Report
RE: Many-to-many relationship

Hi,

I can see you have created another relationship with Contact (as lookup) named Freelancer. This will be empty if you do not fill it. There is no need of it as you have created a many-to-many relationship.

There are 2 forms and you need to set it as following:

Contact: on the subgrid and select Certifications table here (many to many relationship).

Contact (freelancer): on the subgrid select Certifications table here (many to many). If you have multiple relationships, you need to select the correct one.

Also, you cannot show Freelancer in the subgrid on the Contact, because it is already showing data related to current account. Remove this column form the view.

Similarly, when you open certification, you should only see list of freelancer (not certification names).
Suggested answer

Nya 29,058 on at

Like (0)

Report

RE: Many-to-many relationship

Hi,

This is the same reason why you can't show the category of the certificate in the contact view.

Each row of the Sub-Grid in your screenshot represents one record of a certificate, which can correspond to multiple Contacts and cannot uniquely identify a Freelancer.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya
Suggested answer

Wahaj Rashid 11,319 on at

Like (0)

Report

RE: Many-to-many relationship

Hi,

On the certifications form sub-grid, you should select Contact as related table.
mithun_m 15 on at

Like (0)

Report

RE: Many-to-many relationship

Hi,

I did that changes you mentioned, however I'm now facing a new issue.

Kindly help!
mithun_m 15 on at

Like (0)

Report

RE: Many-to-many relationship

Hi,

Thank you for replying.

The sub-grid configuration is as shown below:
Suggested answer

Nya 29,058 on at

Like (0)

Report

RE: Many-to-many relationship

Hi,

It’s something wrong with the view you selected for the sub-grid.

You need to choose a view for Contacts. It can be set with a coming with the system one or customized one.

What’s more, the Category in Fig-3 cannot be set in the view of Contacts for the N: N relationship between the two entities. (A contact can have more than one certificate, which means there can be more than one category. A row in this View corresponds to one contact record and cannot display multiple categories.)

After saving and publishing the form, you’ll get the sub-grid of contacts in the form of certification.

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya
Wahaj Rashid 11,319 on at

Like (0)

Report

RE: Many-to-many relationship

Hi,

Thank you for your query.

Can you share your sub-grid configuration on the Certifications form?