Tables
Tables are the fundamental objects in any database. They are the objects in which you store and manipulate data. This is true no matter what kind of data you need to manage. When you create a new database, you begin by building the tables. Later, you create pages and reports in order to access and view the data in the tables.
The following sections provide an overview of how to locate Help about designing tables in Microsoft Dynamics NAV.
Creating Tables
This section explains how to design tables to store your data and set up table descriptions that can ease sophisticated data manipulation.
| To | See |
|---|---|
Learn about the Microsoft Dynamics NAV approach to tables in database design. |
|
Design and develop a basic table in Microsoft Dynamics NAV. |
|
Decide which field data type to apply to your data. |
|
Apply table and field properties and create effective table descriptions. |
|
Connect table data through primary and secondary keys. |
|
Learn about Microsoft Dynamics NAV features designed to speed up data manipulation and computation. |
Using Triggers in Database Design
Microsoft Dynamics NAV supports setting up actions to take place in response to specific events. These are known as triggers. The following topics help to explain how Microsoft Dynamics NAV implements this feature of database design.
| To | See |
|---|---|
Learn about the set of triggers that Microsoft Dynamics NAV supports for tables and fields. |
|
Create a table trigger. |
|
See reference information about specific triggers. |
Designing Relationships Between Tables
In Microsoft Dynamics NAV, the primary way to establish a connection between tables is to use the TableRelation property. The following topics go into detail about how this works.
| To | See |
|---|---|
Get a brief introduction to relational database design in Microsoft Dynamics NAV. |
|
Understand the extra steps SQL Server requires to use the TableRelation property. |
Understanding SQL Server and Linked Objects
Microsoft Dynamics NAV supports special handling for SQL Server Object tables. You can find help on linked objects in the following topics.
| To | See |
|---|---|
Learn about the LinkedObject table property. |
Creating Table Definitions from SQL Server Objects (Linked Objects) |
Work with other data sources, including Microsoft Excel and Oracle databases. |