Tagged: View

Using SQL Views in Navision

code-dynamics

Did you know that it is possible to use views in Navision?

If you often are collecting/viewing data from several tables it can be usefull to use a SQL View. Created SQL Views can then afterwards be used from Navision.

First you have to create the SQL View. This is can be done in 2 ways on the SQL Server.

One way is to use the Microsoft SQL Server Management. Here you right click on View select New where you afterwards can select tables, joins, fields etc.

Read more »