Adding additional data to the query

We will go further into the example by adding a couple of extra data items to the query.

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 table Item.
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 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 following screenshot:
   
6. Close the Properties window.
7. For the Item data item, select the field Description as the Column type in the rows below the DataItem field.
8. On the first empty row, enter a new data item and select Customer as the Data Source.
9. Open the Properties window for the Customer data...