Tuto WEBDEV 25

200 Part 5: Let’s continue the development The description window of query is as follows: At this time, this query is used to select all orders and the corresponding order lines. We are now going to reorganize the query items. Indeed, this order will be used to create the different controls of the report based on this query. We want the product caption to be positioned just after the product reference. ▶ To reorganize the order of items: 1. Select the ProductCaption item of the OrderLine data file. 2. Click on the right of the list of items. The item moves up. 3. Position the item just after the product reference (OrderLine.Reference). We want to select the data corresponding to a single order whose identifier is known. Therefore, we are going to define the order number in parameter. ▶ To manage the "Order identifier" parameter: 1. Select the Orders.OrdersID item (in the middle of the screen). 2. Click in the fourth column: select "New condition". Remark When describing a query, the section that lists the query elements includes 4 columns: • The item name, • The ability to display (or not) the item in the query result, • The sort management for the item, • The number of conditions associated with the item. To access one of these characteristics, all you have to do is click in the corresponding column.