Properties of pages and tables

Question

Accepted Answer

Properties of pages and tables in Navision

Pages in Navision are used to display and interact with data
Tables in Navision store the data
Pages have properties like SourceTable, Caption, and PageType
Tables have properties like TableType, DataPerCompany, and DataCaption
Pages and tables can have triggers and actions associated with them

Accepted Answer

In Microsoft Dynamics NAV (formerly Navision), pages and tables are two important types of objects used to create customized business applications. Here are some key properties of pages and tables:

Properties of Pages:

SourceTable: This property specifies the main table that the page is based on. The SourceTable property is used to define the data displayed on the page, and to specify which fields from the table will be displayed.
Caption: This property specifies the caption or title of the page, which is displayed at the top of the page.
Type: This property specifies the type of page, which can be either Card, List, or Worksheet. A Card page displays a single record at a time, a List page displays multiple records in a table format, and a Worksheet page displays data in a grid format.
Actions: Pages can contain various types of actions, such as actions that open other pages, run reports, or execute custom code.
Properties: Pages can have various properties that affect how they behave, such as whether they are editable, whether they allow filtering, and whether they allow sorting.

Properties of Tables:

Fields: Tables consist of a collection of fields, which define the data that is stored in the table. Each field has properties such as Data Type, Caption, and Validation Rules.
Primary Key: Every table must have a primary key, which is a unique identifier for each record in the table. The primary key is typically made up of one or more fields.
Relationships: Tables can have relationships with other tables, which are used to define how data from different tables is related. Relationships are typically defined by specifying a foreign key in one table that corresponds to the primary key in another table.
Triggers: Tables can have various types of triggers, such as OnInsert, OnModify, and OnDelete. These triggers are executed when records are inserted, modified, or deleted from the table, and can be used to add custom functionality or validation rules.
Properties: Tables can have various properties that affect how they behave, such as whether they are editable, whether they allow filtering, and whether they allow sorting.

Overall, understanding these properties of pages and tables is important for customizing and developing business applications in Microsoft Dynamics NAV.

Properties of pages and tables

Top CorporateServe Solution Navision Technical Consultant interview questions & answers