Tables Relationship's structure

Frank101 · 2005-07-12

Table Relationship's structure

I’m learning report and form design in Navision 3.1 :? , is they any way to know the relationship between the tables so I can design the forms and reports easily. Something like the relationship maps in MS Access.

This is an example where I found it difficult to find the relation between the vendor and Sale,
I’m trying to design a form that displays the Vendor’s sales by period in a matrix as follows

Store Filter
| Vendors | Jan | Feb | Mar | …
| V100 | 500 | 152 | 125 | …
| V121 | 254 | 132 | 321 | …
| …….

I’m new to Navision , the only reference i have to learn it is the Application Designer’s Guide.

Luc_VanDyck · 2005-07-12

You can try following downloads to gather some info about the database structure:

tBrowser v1.2
NaviTools ER Diagram v1.2 for Microsoft Navision

Timo_Lässer · 2005-07-12

Frank101 wrote:

[...]
I’m learning report and form design in Navision 1.3
[...]

Did you realy wrote "Navision 1.3" or what did I read :?:
Navision 1.30 is more than 6 Years old :!:
Current version is 4.0

Back to your question:
Have a look at tBrowser v1.2. This is a nice tool to get the table relations but I don't think that this will work with Navision 1.3

Frank101 · 2005-07-12

Thank you guys , that was a great help.

Sorry for the typo it is version 3.1 not 1.3

Tables Relationship's structure

Comments

Categories