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

  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at
    RE: A Self Referencing Lookup with the Value of Present Record.

    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.

  • Community Member Profile Picture
    on at
    RE: A Self Referencing Lookup with the Value of Present Record.

    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
    Arun Vinoth Profile Picture
    11,615 Moderator on at
    RE: A Self Referencing Lookup with the Value of Present Record.

    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.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
dkrishna Profile Picture

dkrishna 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans