Introduction

Microsoft Dynamics NAV systems store business information (data) in tables. Tables may be visualized as two-dimensional matrices consisting of columns and rows. Data stored in a table can be viewed by clicking on Run in Object Designer. Each row is the record and each column is the field, as shown in the following screenshot:

Note

NAV 2013 displays table data in the RTC client, so it is necessary to have NAV Server and Microsoft SQL Server (which is holding the NAV database) configured and running even for viewing data from NAV Developer Environment. Be careful! It is easy to accidently change something while executing the table with Object Designer.

A table can be divided into two parts: table data and table design. Table design comprises properties, triggers, fields, and keys. The following diagram can help to understand how all these are related to each other:

Microsoft Dynamics NAV 2013 introduced a new object named Query; it helps you retrieve data from one or more tables as...