How to make schema table for NAV 2015?
How can I link the tables based on their primary keys?
Should I use SQL server queries to create new tables and link them using primary keys ?
Microsoft dynamics is mainly driven my the development Environment. The changes you make there are then synchronized to the SQL tables. Synchronization is the process of ensuring that the tables and their structure in Nav is the same as that in SQL.
So whats the problem with making changes in SQL? Synchronization is one way, From Nav to SQL. This effectively means that changes made on sql cannot be automatically replicated in nav. This results in SQl synchronization errors when you open the Role tailored client thus rendering the application unusable
I have created E/R diagrams for Navision 4.0 (http://navitools.com).
...and NAV 2016: https://dynamicsdocs.com