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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / DIXF: Populate the Par...
Finance | Project Operations, Human Resources, ...
Suggested Answer

DIXF: Populate the Parent RecId and assign it to Child Table Field during staging?

(0) ShareShare
ReportReport
Posted on by Community member

Hi

I'm working on a data management import project (XML) in d365FO. I have composite Entity that has 2 tables in it.

T1 and T2. T1 as the parent and T2 as the child.

T2 has 3 fields.

TableId - TableId of T1 (index)

RefRecId - RecID of T1 (index) this is a foreign key

Field1 - The value of this field is from the XML file being imported.

Now during staging I need to populate values in t2.tableid and t2.refrecid which are the parent table's tableId and RecID.

How do I populate the recID and TableId of the parent and assign it to child table fields during staging?

Any help would be appreciated

I have the same question (0)
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,634 Moderator on at
    Do you mean staging means while importing? If yes, you can use mapentitytodatasource method which is OOB functionality for this part.
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at
    Hi Hanna,
     
    Using record IDs for linking data using data entities is not the correct approach. When you import data from a source file into T1 and T2, the records will get new record IDs so you can't make the correct link using record ID references in data entities. The idea from data entities is replacing record IDs with a natural key. In this example, you would need to use the natural key field value from T1 as value in T2 to be able to make the reference.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans