Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

How to map two entities in CRM

(0) ShareShare
ReportReport
Posted on by 15

Hello,

I currently have two entities "Account" and "Quote_custom" .(1:1 Relationship)

Account has account ID and Quote_custom has the same account ID as well.

All I need is to see the relevant Quote_custom record in the account form. Ideally, system should match the account id in both entities and populate relevant Quote_custom record.

How do I achieve this? Any advice is appreciated. Thanks

*This post is locked for comments

  • KaushalK Profile Picture
    KaushalK 15 on at
    RE: How to map two entities in CRM

    Thanks for all your suggestions. I fixed the issue by directly loading accountID to the lookup field via SSIS package. Now all related records are coming up. Thanks again!

  • Aparna1 Profile Picture
    Aparna1 218 on at
    RE: How to map two entities in CRM

    Hi KaushaIK

    You can use quick view forms to display the relevant Quote_custom record. You will have to first create the 1:N relationship between Account and Quote_custom and then create a quick view form for Custom_Code.

    Add this quick create form in the place on account form where you would like to populate the data.

    Use the below link to create quick view forms:

    [View:https://docs.microsoft.com/en-us/dynamics365/customer-engagement/customize/create-edit-quick-view-forms:750:50]

    Regards

  • Suggested answer
    Iswarya Profile Picture
    Iswarya 1,345 on at
    RE: How to map two entities in CRM

    Hi,

    first create 1:N relationship between Account and QuoteCustom. after create subgrid in Account entity . now u can see the Account related QuoteCustom Records in Account form

  • Suggested answer
    Temmy Wahyu Raharjo Profile Picture
    Temmy Wahyu Raharjo 2,914 on at
    RE: How to map two entities in CRM

    You can make workflow/plugin that basically will set the quote_custom.new_accountid. If you only want the latest value, then your plugin needs to update last quote_custom.new_accountid = null. Then you can show subgrid in Account form with filter by current account.

  • Suggested answer
    Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: How to map two entities in CRM

    there's no such thing as a 1:1 relationship in CRM.

    make an account lookup on Quote_custom; build a quick view form on quote_custom; add that form to the account form(s) connected through that lookup.

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,253 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans