web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Table relationships and surfacing data in a form

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

I hope someone could advise me on the following issue I am facing with in my Dynamics app.

I have the following tables that I am using in my app: Contacts, Enrolments, Cases and Study Aim Status.

On the main Cases form, I am using a quick view form to display some selected information associated with a contact (full name, email, etc). However, I also need to be able to display information from the Study Aim Status table on the main Cases form, which is my issue.

I have the following relationships going on:

Study Aim Status and Enrolment have one-to-many relationship.

Enrolment and Contact have many-to-one relationship.

Cases and Contacts have many-to-one relationship.

I am struggling with surfacing information from the Study Aim Status on the main Cases form. I am able to display information about the contact, but I also need to show their study aim status, which is displayed on the enrolment form as there is a relationship between the enrolment table and study aim status table.

Could someone advise what relationship am I missing to correctly display the study aim status field from the study aim status table?

Many thanks, 

Alex

I have the same question (0)
  • Verified answer
    Bipin D365 Profile Picture
    28,983 Moderator on at
    RE: Table relationships and surfacing data in a form

    Hi,

    You can only go 2 level down to show records related using quick view form by adding the subgrid on quick view form.

    As per your description you are looking to show 3rd level down data on Case which I am afraid not possible OOB.

    However you can add HTML web resource to show that details

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 242

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 85 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 72 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans