You’re offline. This is a read only version of the page.
162
Hi Everyone,
I have a question relating lookup-fields and associated views: In our Cases we added the option to pick more than one Asset, that this Service Case relates to.
So there are three look-up fields. But when I click on the Assets to see, that Cases are connected to it, only the one in field "Asset" (the OTB Asset lookup in the Case Main Form) shows the specific Case in the Associated Case view. Asset 2, for example, doesn't show it.
Can anyone explain to me why and how I can fix this?
Thank you so much in advance!!
Aaah yes amazing now it's exactly what I was looking for!!
I added the Asset-Subgrid to the Case form so that we can now add Assets via "Add Existing" and on the Asset form I added a subgrid with "All related Cases" and it shows alle the cases - perfect!
In this way I can get rid of my "Asset 1, 2, 3" fields as well.
THANK YOU !!
Hi,
Once you create N:N relation between Case and Asset, you will need to open Form editor and click Insert tab then select Subgrid -
Now Save and Publish your changes. This is how it will look like on form where you add existing multiple Assets-
I have associated two assets. Now If I go back to Asset form ->Related Tab-> I would see Cases for N:N
You are seeing four because I have also added 3 Asset lookup of the form.
3 lookup and 1 N:N relationship so 4 related tabs for Cases.
You could also modify the names so distinguis the related tabs by opening the Asset form and modify the Navigation properties.
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: xrmdynamicscrm.wordpress.com/
Thanks for the reply. Unfortunately not :(
I still only see related cases for the one asset that is filled in the ootb field "Asset" on the case form. The assets that are filled in my custom look ups "Asset 2" or "Asset 3" are still not shown in the related tab.
After publishing you should be able to see assets via the related tab on the case form.
Hi Timothy,
I know you answered quite a while ago - thanks again for that and sorry for the late reply: So I tried this and created a many-to-many relationship between Case and Asset. But I just don't know what to do next? I still don't see more than one related Asset to a Case.. Is there anything else I need to create / change ?? I did not delete the standard 1-n relationship between Asset and Cae, might this be an issue?
Thank in advance for assistance
Normal relationships in Dynamics are a one-to-many-relationship. So one asset relates to many cases. With a many-to-many-relationship you can create a relation between many assets and many cases. One both sides, the other records show as a list instead for a lookup field on on of the records.
Pleas find more info from Microsoft here: docs.microsoft.com/.../create-edit-nn-relationships
The two assets are two different relationships with case. They cannot be combined in one view. What you can do is create a tab with two different subgrids. One for the asset showing as Asset on cases and one for the asset showing as Asset 2 on cases.
Alternatively you could go for a many to many relation between asset and case.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (