Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

Posted on by

I don't know if it is possible but i want to update a parent record field and have a field update on the children record field automatically.

*This post is locked for comments

  • Theohox13 Profile Picture
    Theohox13 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    thankyou for taking the time to clarify this

  • Verified answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    Theohox,

    Have you tried this one?

    crm2011distributewf.codeplex.com

    bingsoft.wordpress.com/.../distribute-workflow-activity

    This is easier than you create new one.

    The steps:

    community.dynamics.com/.../tip-169-update-related-records-with-a-workflow.aspx

    There is no way unless you use custom workflow or plugin.

    But, you can use the library instead of creating new one.

    OOB Workflow cant work to update relate child records in CRM.

    Thank you.

  • Theohox13 Profile Picture
    Theohox13 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    I don't know how to do custom workflow because i don't know any code...i guess there is no solution for us

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    So, it is self-referential?

    But, again the concept here Theohox, You cannot update child records (all) if field from Parent is changed.

    Other way, you can change field in the Parent record if Child record field is changed before.

    In your workflow, you update the entity itself, not the child.

    Hope this helps.

    Create a custom workflow.

    Thank you.

  • Theohox13 Profile Picture
    Theohox13 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    Meeting report is the same as Case (i changed the name)

  • Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    Theohox,

    You cannot modify the child records based on the parent using the OOB Workflow.

    What is your trigger point?

    Your parent here is the Parent Case and your child entity is Meeting Report.

    But you set the field change on the Meeting Report entity, in fact the Parent Case is the one that is updated, not the Meting Report.

    You need to create a custom workflow activity to distribute field from parent to all children, cannot use OOB Workflow, you can update Parent if child is updated using OOB Workflow, but not the opposite way.

    Hope this can help you to understand this.

    Thank you.

  • Theohox13 Profile Picture
    Theohox13 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    Ive tried to create a workflow but i am having some problem and i dot know why. The workflow says Success..

    Ref1.png

    Reference the Parent

    Workflowsuccess.png

    Says the workflow went through

    why.png

    Nothing happened

  • Suggested answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,522 on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    Theohox13,

    You need to create custom workflow activity or plugin for this...

    The concept is finding all children related from this entity record then get the parent field value, then update all children field value with this parent value.

    There is no OOB functionality for this.

    Thank you.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Map a Field in a Parent Record to the same or different Field in all Child Records (hierarchy)

    If I am understanding the question correctly.......big if!!

    You can do this by using Business Rules

    When record A is populated / selected etc...Record B or C or D is 'this'

    You can also with business rules have fields become visible or hidden along with populated

    Hoep this helps

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

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