You’re offline. This is a read only version of the page.
15
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.
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
Hi,
The forms I have are:
I have created only one relationship.
Contact Form:
Certifications Form:
I'm unable to figure out the solution.
This is my requirement:
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?
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:
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).
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
Hi,
On the certifications form sub-grid, you should select Contact as related table.
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
Hi,
Thank you for your query.
Can you share your sub-grid configuration on the Certifications form?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (