All Table Relations from NAV

kine

If you want to browse the table relations in your database, you can use the tool I released on the "The Art Of NAV" project pages under name "The Big Picture of NAV".

I will send it to Luc to upload it into Download section on Mibuso too...

You can find diagrams with all the relations on this project too. More about these files you can find on my blog.

But you must know, that there are 5468 table relations in the W1 version of NAV 5.00SP1 (conditioned relation to three different tables from one field is counted as 3 relations). And it means that any graph of this is very, very, very hard to use...

kine

There is new version on the site, including the FlowFields in the list...

Alex_Chow

kine wrote:

There is new version on the site, including the FlowFields in the list...

Just curious, what project were you guys working on that prompted you to get this chart out?

kine

none... :-) just thought about it for few years, when from time to time someone asked "have you the data model of NAV?" Now, I can say: "Yes, we have, and what you will do with it?"

kriki

Just for completeness : this is a link to the download-section : http://www.mibuso.com/dlinfo.asp?FileID=990

kine

kriki wrote:

Just for completeness : this is a link to the download-section : http://www.mibuso.com/dlinfo.asp?FileID=990

Yes, thanks... ;-)

But still, I do not know why the old version on the google have over 27 000 downloads and the new one only 16. :?:

Alex_Chow

1. Probably competitors trying to understand the structure of NAV. :shock:
2. Probably some development company out there trying to create an ERP software :shock:
3. Probably someone who's bored.

archer89

hello kine, does this solution also work for the newer nav versions? do you plan to upgrade it? would be great. regards

kine

we will see... had no time few years to look at this again... but because the table structure was not changed too much, I expect it should still work even for NAV 2016 objects... but you need to run it on some old classic client. Reworking the tool under RTC should be easy for you... ;-)

archer89

hi kine, the form 66000 needs a (sample?) input file tabs.txt for processing. it's not included in the download.
what is the structure of that file? why is it needed ?
please add a sample file. thx.

kine

TXT should be just standard txt file exported from object designer with all tables you want to include...