In Dynamics you can only select one relationship in the subgrid for one table. Is there a way to customize the subgrid with your own query?
I would like to show all related records based on two relations from one table.
Example: selected contact = ‘Peter’ has two relations to table "connections"
Result should show all records where column A =’ Peter’ or column B = ‘Peter’
query example:
SELECT *
FROM Contact
WHERE Column A = Peter
OR Column B = Peter
maybe I didn't express myself well. Again: I would like to show two relationships in one subgrid. See the screenshot.
I would like Connections (Role From Contact) AND Connections (Role To Contact), related to contact where the subgrid is in.
Go to the sub-grid. Get the view name which is used.
Now update the filter criteria as per your requirement u will have to add OR condition in the view, Publish and check it after that.
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...
290,349
Super User 2024 Season 2
#2
Martin Dráb
228,212
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (