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
