Tables in Microsoft Dynamics NAV
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 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 Dynamics NAV approach to tables in database design. | Overview of Tables |
| Design and develop a basic table in Dynamics NAV. | How to: Create a Table |
| Decide which field data type to apply to your data. | Field Data Types and Data Format Considerations |
| Apply table and field properties and create effective table descriptions. | How to: View or Modify Properties on a Table or Field |
| Connect table data through primary and secondary keys. | Table Keys |
| Learn about Dynamics NAV features designed to speed up data manipulation and computation. | Accessing Microsoft Dynamics NAV Tables with External Tools |
Using Triggers in Database Design
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 Dynamics NAV implements this feature of database design.
| To | See |
|---|---|
| Learn about the set of triggers that Dynamics NAV supports for tables and fields. | Table and Field Triggers |
| Create a table trigger. | How to: Define or Modify Table or Field Triggers |
| See reference information about specific triggers. | Triggers |
Designing Relationships Between Tables
In 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 Dynamics NAV. | Setting Relationships Between Tables |
| Understand the extra steps SQL Server requires to use the TableRelation property. | Maintaining Table Relationships on SQL Server |
Understanding SQL Server and Linked Objects
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. | Accessing Objects in Other Databases or on Linked Servers |