Navision Technical Consultant Interview Questions and Answers

There are three types of keys in Navision: Primary Key, Foreign Key, and Unique Key.

• Primary Key: A primary key is a unique identifier for a record in a table. It ensures that each record is unique and can be used to establish relationships with other tables.

• Foreign Key: A foreign key is a field in a table that refers to the primary key of another table. It establishes a relationship between two tables.

• Unique Key: A unique key ensures that the values in a specific field or com...read more

Setrange and Setfilter are methods used in Navision to filter records in a table.

• Setrange is used to set a single filter on a field, while Setfilter is used to set multiple filters on multiple fields.

• Setrange can only be used on primary keys or indexed fields, while Setfilter can be used on any field.

• Setrange can only be used to filter for equality, while Setfilter can be used for various types of filters like range, wildcard, or logical operators.

• Setrange is faster than Setf...read more

Triggers, reports, pages, and tables are key components in Navision development.

• Triggers are used to execute code before or after certain events occur in a table.

• Reports are used to present data in a structured format for printing or viewing.

• Pages are used to create user interfaces for data entry, modification, and display.

• Tables store and organize data in Navision, serving as the foundation for other components.

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