Programming Microsoft Dynamics NAV - Fifth Edition

Lookup related table data

Once we have a successful test of the report (heading only), we'll move on to laying out the body of the report. As we think through the data, we will want to include a mailing address, such as Name, Address, Address 2, City, County (State), Country Name, and Post Code, and realize that our table data includes Country Code, not Country Name. So, we will look up the Country Name from the Country/Region table (Table 9). Let's take care of that now.

First, we'll add a couple of Global Variables to our report. One of them will allow us to access the Country/Region table, and the other will act as a holding place for the Country Name data we get from that table, as shown in the following screenshot:

Each time we read ...