Is there a way to obtain an Entity Relationship diagram of how tables are joined between one another in Navision (e.g. "Sales Header" with "Sales Line").
Yes and no - if you search this forum for this, you can find some topics abot that
shortly:
if you are using MS SQL and turn on the Maintain relations, you can create DB diagram in MS SQL.
In download section is tool for creating Visio diagram.
But - problem is, that in this diagram are not included conditional relations... (for example field No. in sales line which can be connected to Item, Resource, G/L etc...)
Comments
shortly:
if you are using MS SQL and turn on the Maintain relations, you can create DB diagram in MS SQL.
In download section is tool for creating Visio diagram.
But - problem is, that in this diagram are not included conditional relations... (for example field No. in sales line which can be connected to Item, Resource, G/L etc...)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.