Relation between table

(0) Share

Report

Posted on by Community Member

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)

All responses (17)

Answers (4)

Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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

Not possible as per your link.

Was this reply helpful? Yes No
RockwithNav 8,637 Super User 2025 Season 2 on at

Like (1)

Report

Hey Kamilla,

Please refer the following links.

https://www.youtube.com/watch?v=jyklg0cTN3M

http://shantanu-msd-nav.blogspot.in/2014/09/msd-nav-table-field-relationship-part-i.html

Thanks

Blog - rockwithnav.wordpress.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
RockwithNav 8,637 Super User 2025 Season 2 on at

Like (1)

Report

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/

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
RockwithNav 8,637 Super User 2025 Season 2 on at

Like (1)

Report

Hey Kamilla,

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

Thanks

Blog - rockwithnav.wordpress.com

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

yes .

Was this reply helpful? Yes No