Table relations View

(0) Share

Report

Posted on by Community Member

Hi there,

Please I wanna show relations between tables in Navision, for the sake of clarity i give you straight forward a simple example where i have the table Item and the table Sales invoice lines where there is items invoiced there (field item in table sales invoice lines), i wanna show the relation between the two tables (key of the first table and key of the other table for example).
How can i do in order to show the relation because i can't target it neither in Microsoft SQL Server Management Studio by clicking show dependencies (they gave me no other tables in relation), neither in Navision itself by seeing table relation in properties of fields in tables.
Please help me with this and i'll be ultimately thankful!

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Verified answer

Hannes Holst 5,767 on at

Like (0)

Report

Hi,

NAV provides a system-table called "Field".

This table contains all fields and the corresponding relation.

Really old-school ;-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

First of all, thank you for your response but i can't locate the table "Field" as shown below.

Can you help me further please.

Thanks again!

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

It is not available in the object designer, create a new form/page and for type field for table name and that is the only you can view the data of the field table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

What do you mean by "and for type field for table name"?

Thanks!

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

What Suresh mean is that you need to create a new list form in Object Designer. Use the wizard and as SourceTable set "Field" (the name of this NAV virtual table). Then save the list form (for example 50000) and run it. You will see all fields and relations.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Stefano,

Thank you for your help, i did exactly what you said but it didn't work.

Below the steps i did as you told and the message that appeared when i'm trying to save the table.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

This is a problem related to NAV License. Are you using a developer license or a customer license? So strange that you cannot create Page 50000. Check your license and save the object in your permitted license range.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi again,

I'm on Nav 2018 Demo Database, I just wanna look inside the virtual table "Field" to see how tables are related to each other (for example how do I easy see all the locations of a certain field name in the database).

If you can help to do so with another way please enlighten me.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Click Preview and you should be able to see the page. I suggest to change your license in Development Environment.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

You need to have Application Developer or Solution Developer License to create the Objects, if you don't have it then you cannot create them. You need to contact the partner.

Was this reply helpful? Yes No