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 NAV (Archived)

Relation between table

(0) ShareShare
ReportReport
Posted on by

Hi everyone, i want to know the relation between each table and by which column are related to.i don't have a licence .I follow this link  https://msdn.microsoft.com/en-us/library/hh174016%28v=nav.70%29.aspx to identify each table and her column but i didn't find any documentation about how they related.thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mohana Yadav Profile Picture
    61,005 Super User 2025 Season 2 on at

    we need to use Where Used tool of Object manager I guess.

    Not possible as per your link.

  • RockwithNav Profile Picture
    8,637 Super User 2025 Season 2 on at
  • Community Member Profile Picture
    on at

    thanks but  this link shantanu-msd-nav.blogspot.in/.../msd-nav-table-field-relationship-part-i.html dosn't contain all the tables .Do you have an other part?

  • Verified answer
    keoma Profile Picture
    32,729 on at

    You can use "The big Picture for Nav" from Kamil Sacek. It works for Nav 5 and Nav 2009. I'm working on a version for the newer Nav versions. To get all the table relations in the tool, you must have a dev. license, because first step is the text export of all tables. this exported text file is then imported to & processed in that tool. also possible, someone else exports the tables for you and sends you that file.

    http://mibuso.com/downloads/the-big-picture-of-nav-v2

    I'm also working on a version, where a dev. license is not needed.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Kamilia,

    Since you do not have developer license, please elaborate your requirements in details

    May be then we can then help you provide you more details on the same.

  • RockwithNav Profile Picture
    8,637 Super User 2025 Season 2 on at

    Hey Kamilla,

    If you are trying to figure out the positive relation between each and every table available in Dynamics NAV than i belief it's something you cant find anywhere, you only have to analyze.

    Secondly if you are concerned with certain bunch of tables then you can say and will look it for you. The third simplest way is to identify it with the Navigate button available in the Pages like Posted Sales Invoice, Ledger Entries and all. Once you will click you will find the available tables you just need to open and zoom it out and you will find the corresponding matching Fields.

    Thanks

    Blog - https://rockwithnav.wordpress.com/

  • Suggested answer
    Community Member Profile Picture
    on at

    yes, i don't have a developer licence so i'm trying to find an other solution . the tables of sales module msdn.microsoft.com/.../hh915508%28v=nav.70%29.aspx

  • Suggested answer
    Community Member Profile Picture
    on at

    if you could generate a file .txt for me then i can use any tools that determinated the relation between tables.

  • RockwithNav Profile Picture
    8,637 Super User 2025 Season 2 on at

    Hey Kamilla,

    Which .txt file you want??  Do you want all NAV Standard Table Objects in .txt??

    Thanks

    Blog - rockwithnav.wordpress.com

  • Suggested answer
    Community Member Profile Picture
    on at

    yes .

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 NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans