Table relations

Table lookups are everywhere in NAV. You create a sales order and select a customer from a list of all customers in the system. When you add a line to the order, you use lookups to choose an item, location, and item unit of measure. Any time you select a value from a lookup list, most likely there is a table relation behind this selection.

The following example shows how to set up a table relation for the Customer No. field in the Lease Contract Header table. This configuration will enable page lookup functionality and help the user easily select a customer from a contract:

  1. Open the 50500 Lease Contract Header table, in the table designer.
  2. Select the Customer No. field and navigate to its properties (View | Properties).

Get Microsoft Dynamics NAV Development Quick Start Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.