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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Self relation in a table
Microsoft Dynamics AX (Archived)

Self relation in a table

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am a newbie to AX and I came across below relation which I didnot understand.

Table: InventTableModule

Relation name: InventTableModule

Relation details:

InventTableModule.ItemId == InventTableModule.ItemId

InventTableModule.ModuleType == InventTableModule.ModuleType

Can anybody help me understand this relation and the scenario where it can be used?

thanks,

Padmaja

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

    Hi Padmaja,

    This relation seems obsolete to me... The primary key is exactly the same, so it has no use. In some tables there is an ID and a ParentID field. In that case a relation on the same table, but two different fields do make sense.

  • Community Member Profile Picture
    Community Member on at

    Hi Arnaud,

    Thanks for the answer.

    But I have seen the same kind of relation on other tables as well.eg: WmsLocation table. So I am not sure if its obsolete.

    One of my colleagues looked into it and said that it may be used when that table is used in other tables or any other form, but we tried the same and were not successful in finding any explanation.

    So I will wait for other's opinions also before closing it.

    regards,

    Padmaja

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hi Padmaja,

    I know this thread was created a year ago, but just in case someone landed up upon this thread, here's the explanation why such a self-relation exists in a table.

    What your colleagues mentioned is indeed correct. I just ran across this problem a few minutes ago and thought of this solution up.

    If I have a datasource in lets say form A, and I have the SAME datasource in form B, I would like to link form B to form A by clicking on the field value of the datasource (to view  it's detail).

    If I do not link in such a way (e.g: TableName.numId == TableName.numId), I would need to manually override jumpRef to achieve the very same result, which is not cool.

    I hope this helps clear someone with doubts about self-relation in a table.

    Cheers.

    Lincoln

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

    Have also a look at a more recent thread with the same question: community.dynamics.com/.../655456

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans