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

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Mapping (Relationship 1:N): How does it work?

(0) ShareShare
ReportReport
Posted on by

Hello,

I was trying to understand how does the mapping work, because what is happening now is that I added the relationship (1 : N) and then when created, I got in to mapping some inputs.

what I have not really clear is if this inputs are related each other and how they work?

Do I need to add a reference or do something more?

I will appreciate any help,

really thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Royal King Profile Picture
    27,686 on at
    RE: Mapping (Relationship 1:N): How does it work?

    check the below post that provides detailed information on how mapping fields works in the crm

    www.crmcodex.com/.../tutorial-relationship-mappings

    www.zero2ten.com/.../save-time-entering-data-into-crm-by-mapping-fields-between-records

  • Suggested answer
    Mamatha Swamy Profile Picture
    5,426 on at
    RE: Mapping (Relationship 1:N): How does it work?

    When you define mappings in a relationship, CRM pre-fills these fields from the associated record when you create it. You can read more in the below links

    http://msdn.microsoft.com/en-us/library/gg334512.aspx

    here is an example of the usage http://www.powerobjects.com/blog/2012/06/26/microsoft-dynamics-crm-relationship-mappings-help-keep-customer-and-bill-to-customer-consistent/

  • Suggested answer
    Aileen Gusni Profile Picture
    44,524 on at
    RE: Mapping (Relationship 1:N): How does it work?

    Ken,

    For the detail info you can see those links provided before, then answering your question:

    "what I have not really clear is if this inputs are related each other and how they work?

    Do I need to add a reference or do something more?"

    As long as the entities are related then it is fine.

    For example there are 2 entities:

    Account and Project

    Then, you have two identical fields:

    Industry in both entities with same global optionset.

    And also

    Which you want to mapping those fields. If you create a project from relates Account Classification or Account level field and address field that you want to inherit

    Then once you are in the account form then you go to Project subgrid or associated view then you create a new Project record from that Account

    Sample data:

    Account

    Name = Bank of England

    Industry = Banking

    Level = Platinum Class

    Address = St Louis 23, Newcastle

    Then you have a new Project MS Dynamics CRM implementation in that bank you want to make sure that once you or users create the new project will be by default those fields are auto populated.

    So you need to define those fields in the mapping in your 1 to many Account and Project relationship.

    The things that you need to make note are:

    - You only can do mapping from the related entities, this is the main concept

    - Mapping is only works from Parent to Child, cannot from child to parent

    - Mapping only works for the fields that are having same types and if you want to map the optionset field you must define as global option set, you cannot inherit lookup to option set and vice versa

    - it will work if only you create the child record from the parent, through subgrid or associated view, it wont work if you create the project outside the parent from blank form then you later key in account field, it wont inherit the fields mapping define before.

    Hope this helps!

    Thanks

  • Community Member Profile Picture
    on at
    RE: Mapping (Relationship 1:N): How does it work?

    Hello, thanks a lot to replay Aileen.

    I performed the mapping process, I did it successfully. I added a look up relationship and then I mapped some other inputs, but at the moment to chose in the look up input, I have no idea why it didn't fill all the mapped inputs I set!

    Do you have any idea?

    Thanks a lot !

  • Suggested answer
    Aileen Gusni Profile Picture
    44,524 on at
    RE: Mapping (Relationship 1:N): How does it work?

    Ken,

    As explained before, if you create the record and then choose the lookup to get related parent record, the mapping wont work because it does mean the record was created from outside not from parent context.

    Hope this helps.

    Thanks.

  • Community Member Profile Picture
    on at
    RE: Mapping (Relationship 1:N): How does it work?

    Hi, I am sorry, I feel shame, but honesty still confused.

    Do you have an idea any tutorial that you can recommend me, with insertion of data, all entire steps?

    Thank you so much, my apologies.

  • Aileen Gusni Profile Picture
    44,524 on at
    RE: Mapping (Relationship 1:N): How does it work?

    Ken,

    Check the links provided by Chitra/Mamatha.

    Basically, you can only create record from subgrid or associated view in the Parent form to get the mapping works.

    Thanks.

  • Community Member Profile Picture
    on at
    RE: Mapping (Relationship 1:N): How does it work?

    I thought it was me, but this process doesn't work, I don't know I don't know if it was because it was the trial version of the CRM that I'm using.

    But I found another way to do something similar:

    community.dynamics.com/.../retrieving-data-from-a-related-entity-with-real-time-workflows-in-crm-2013.aspx

    I found this article in the following block of a guy who has exactly the same problem:

    https://community.dynamics.com/crm/f/117/t/116447.aspx

    If somebody know how to fix it, using this process of mapping, I will be very glad!

    For now thanks a lot for all support!

    Any way, thank you very much.

  • Aileen Gusni Profile Picture
    44,524 on at
    RE: Mapping (Relationship 1:N): How does it work?

    Ken,

    Your first article would help you.

    Create a realtime workflow... will help you to get the related entity record.

    But the contra here is you can only get those mapping after you save.

    If you want to get once you do in form load, you need javascript.

    Thank you.

  • Cyclefitness Profile Picture
    on at
    RE: Mapping (Relationship 1:N): How does it work?

    Thank you, Aileen!!!  Your "things that you need to make note of" section saved me immeasurable frustration!!

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
UllrSki Profile Picture

UllrSki 2

#3
SC-08081331-0 Profile Picture

SC-08081331-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans