Creating a table

Tables are the building blocks for all other Dynamics NAV objects. They store the data that the business needs to access. This recipe will show you how to create a basic table and save it in the system.

How to do it...

1. Create a new table object with Object Designer.

2. Add the following fields in the table designer window:

   Field No.	Field Name	Data Type	Length
   1	Entry No.	Integer
   2	Document No.	Code	20
   3	Description	Text	30
   4	Value	Decimal
   5	Posting Date	Date

   It should look like the window shown in the following screenshot:

   

3. To save the table, go to File | Save (or press Ctrl + S).

In the Save As window, provide values to the ID and Name fields and keep the Compiled checkbox selected to save the table.

How it works...

Each field is just like a variable. These variables, however, are grouped together to form a new type of variable called a record. The field definitions provide the structure for all of the tables, as well as...