Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Connect two Entity using third Entity and use it for view and calculated field

Posted on by 725

I have entity A, B and C.  There are connection between A-B (1:1 relationship), B-C (1:1 relationship).  I want to create a view in A that pulls field from C, without creating and copy the field from C to B, I would also like to build a calculated field on A that uses field from C as parameter, what is the best approach to do this without adding and populating new fields?

Categories:
  • TylerS.Dev Profile Picture
    TylerS.Dev 725 on at
    RE: Connect two Entity using third Entity and use it for view and calculated field

    Thank you for replying, they are all 1:1, as mentioned in the original question article.

    To be more specific, each entity has a lookup field that points to the other with referential type relationship.  A has lookup to B, B has lookup to A, C has lookup to B.  I want C to get field from A based on the lookup field.

  • Priyesh Profile Picture
    Priyesh 7,392 User Group Leader on at
    RE: Connect two Entity using third Entity and use it for view and calculated field

    Hi Tyler,

    Sorry, can you please mentioned as (1:N) or (N:1), meaning is A the parent of B and B, the parent of C?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans