When you apply data that you have imported from Excel or from a RapidStart package, Microsoft Dynamics NAV uses the mapping values that you have provided for a particular field and automatically substitutes the values in your data with the values linked to the field. How Microsoft Dynamics NAV treats and handles the mapping depends on table relations:
-
If you define a mapping directly for a field in a table, then Microsoft Dynamics NAV uses it.
-
If the field has a relation to another table, Microsoft Dynamics NAV searches for the mapping defined for the primary key field in the related table. The related table, however, must be part of the configuration package.
-
If mapping information is defined in both places, for the field directly and for the primary key in the related table, then Microsoft Dynamics NAV will search for the mapping in both places.
-
If the same mappings are defined directly for a field and in the related table, but have different new values, the mapping that is defined directly for the field takes priority over the mapping that is defined for the table that the field is referencing.
Example
The following example illustrates how Microsoft Dynamics NAV implements mapping definitions.
-
Create a configuration table that has a Salesperson/Purchaser table, table 13. Define a mapping for the Code field. For more information, see How to: Map Customer Data.
-
Add additional tables to the package, for example, table 18, Customer, and table 23, Vendor. These tables both reference table 13 through the Salesperson Code and the Purchaser Code, respectively.
-
When you apply data, the mapping that you provided for the Code field in table 13 will also be considered during the processing of the Salesperson Code and Purchaser Code fields.