How to Design a Table in Navision

When you first create a table, it does not contain any data. Nevertheless, when you create the table you must also decide what types of information you want to store in it. The information is held in fields, and each field can be declared as one of the data types that are available.

To create a table
1. On the Tools menu, click Object Designer.
2. Click Table and then click New.

In the Table Designer, for each field you add to the table, you enter the field number, name, data type, and optionally, a length and a description.

How to: Add Fields to a Table

Designing a field means assigning a number of characteristics to it. These characteristics depend on what you intend to use the field for. After you have added fields to a table in Table Designer, you must save the table before you can add any records. After you have saved a table, it appears in the list of tables in Object Designer.

To add a field to a table
1. On the Tools menu, click Object Designer.
2. Click Table and then click New.
3. In the first empty row, enter a Field Name and a Field No. Enter a Data type and appropriate Length. Description is optional.

To Save a New Table

When you design the fields and keys for a new table, you need to save the table in the database before you can use it. After you have saved a table, it appears in the list of tables shown in Object Designer.

To save a table
1. With the focus on Table Designer, on the File menu, click Save.
The Save As dialog box opens.
2. In the ID field, enter a number that will serve as a unique table identification.Note
3. In the Name field, enter the name of the table.
4. Clear the Compiled check box if you do not want the table to be compiled when it is saved.