Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Relations between data sources in Data Entity

(1) ShareShare
ReportReport
Posted on by 122
I'm trying to understand the relationships between tables in the VendorInvoiceHeaderEntity data entity.
 
For example, the property for the HcmWorker datasource under the VendInvoiceInfoTable datasource indicates it's an outer join and Relations will be used:
//
 
Neither of these tables have a relation defined referencing the other table.
 
In the data entity itself, there's a relation called HcmWorker so I thought this would define the relationship but the details are blank:
 
 
//
 
 
How is D365 determining which field(s) to join these two tables on?
 
 
  • JackieMc Profile Picture
    JackieMc 122 on at
    Relations between data sources in Data Entity
    Thank you both so much.  This clears up my confusion.
  • Verified answer
    Layan Jwei Profile Picture
    Layan Jwei 7,634 Super User 2025 Season 1 on at
    Relations between data sources in Data Entity
    Hi Jackie,
     
    When you set "use Relations" to yes, it means that you don't want to insert the relation manually and that you want to use the relation specified on table "VendInvoiceInfoTable" that relates to "HCMWorker" table.
     
    If you set "Use Relations" to No, then you'll need to add the relation yourself which is
    'VendInvoiceInfoTable.Approver = HCMWorker.RecId"
     
    Thanks,
    Layan Jwei
  • Verified answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    Relations between data sources in Data Entity
    Hi Jackie,
     
    If you give "use Relation" property to Yes on the relation property - It will fetch the relation directly from the table. No need to manually mention the related field under relation properties.
    VendInvoiceInfoTable and HcmWorker table is related through Approver and RecId field. Refer to the below screenshot.
     
     
    Thanks,
    Girish S.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans