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:


The following example illustrates how Microsoft Dynamics NAV implements mapping definitions.

  1. 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.
  2. 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.
  3. 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.

See Also