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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

A Self Referencing Lookup with the Value of Present Record.

(0) ShareShare
ReportReport
Posted on by

Hi All, 

We have a Business requirement,  I know in CRM we can Place a Lookup for the same entity in one of its form,   But the Requirement is to Get the Value of the Record itself in the lookup.   I can give a Example 

Let say we have a Account Record with Name "Company Alpha"  I will place a New Lookup which will be of  Account Entity in the Form,  Requirement is when I open the Form in CRM record of "Company Alpha"  In the account record for this Lookup I need to select the "Company Alpha" ?   

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Arun Vinoth Profile Picture
    11,615 Moderator on at

    Not sure what business problem you are trying to solve & business value you are going to get with this field.

    If you want to display the guid value, then you can store it in a text field for display purpose.

    Ok, even if you try to store the same record as related in lookup, did you try to set in post create plugin, any issues?

    I never tried that - but you see any cyclic reference error.

  • Community Member Profile Picture
    on at

    Yes, I know this requirement is weird,  but was just curious if we can Achieve this in some possible way.   I am just trying to get all possible expert suggestions.  Thanks.

  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at

    Hi,

    Did you try this by yourself?

    This is not possible. The term "Self Referential" is used for entities and not for record itself i.e. you can related one account to other but not to itself. This will cause an error.

    Refer below links:

    social.microsoft.com/.../creating-this-parental-association-would-create-a-loop-in-accounts-hierarchy

    community.dynamics.com/.../195623

    titancrm.blogspot.com/.../creating-this-parental-association.html

    Hope 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

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…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans