Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

Adding additional data to the query

We will go further into this example by adding a couple of extra data items to the query. Perform the following steps to do so:

1. In the Object Designer window, select Query 50000 My First Query and click on the Design button. The Query Designer window will open with the query we were creating.
2. On the first empty row, enter a DataItem value for the Item table.
3. Open the Properties window for the Item data item.
4. Click on the Assist Edit button for the DataItemLink property. Select No. as the field, the Item_Ledger_Entry data item as the reference DataItem, and Item No. as the reference field. Click on OK.
5. Back at the Properties window, the value for the DataItemLink property should be what is shown in the ...