Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Database Entity Relationship Diagram Navision v.3.7
gprakates
Member Posts: 2
Hi Everyone,
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").
Any help will be much appreciated.
Best Regards
George
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").
Any help will be much appreciated.
Best Regards
George
0
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.