update child datasource from parent datasource

(0) Share

Report

Posted on by D365FO Avatar

672

Hi Folks,

I want to update a value in a field in one of the child datasource when some fields are updated in primary datasource.

So in which method should I write the logic for updating a field of child datasource. As if I write code in active() method of Primary then it will call everytime unnecessary.

Thanks in Advance!!!

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Martin Dráb 240,534 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

active() it's called when you select a record in a form, not when a record is being saved.

update() method of the table is usually the best place. If the logic is specific to this single form and it should apply anywhere else, use write() method of the form data source.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,214 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @ Community User,

You can add your logic to the Write method of primary Datasource, but I prefer to add it on the modified field (when some fields are updated in primary datasource) of the fields that you want.

Thanks,

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Martin Dráb 240,534 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Note that saving other tables in modifiedField() would be a bug causing data inconsistency. That's because it would update related records before the primary is actually saved, and it may never be saved at all (because a validation fails, a user decides aborting the change, there is a failure and so on).

Was this reply helpful? Yes No
D365FO Avatar 672 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin,

After using write() method of the primary datasource. It worked as required and in last I have update the Datasource with refresh and research methods.

Was this reply helpful? Yes No