Tuto WINDEV 25

Part 4: Full application with data 173 Creating the query used to find orders Creating the query ▶ The query editor will be used to create the query. 1. Click among the quick access buttons. The window for creating a new element is displayed: click "Query". The query creation wizard starts. 2. Select the "Select" option. Indeed, this query will be used to select records. Go to the next step. 3.  The query description window is displayed. To build the query, we are going to select the elements that will be displayed in the result. 4. Double-click the items found in the analysis on the left of description window. The items taken into account are displayed in the middle of the screen. Remark: To display the items of different data files, simply click the arrow in front of the data file name. We want to display: • information regarding the order. Expand the "Orders" data file (click the arrow ) and double-click the items: OrdersID, Date, Status and TotalBT. • information regarding the customer who placed the order. Expand the "Customer" data file (click the arrow ) and double-click the "FullName" item. • information regarding the payment mode of order. Expand the "PaymentMode" data file (click the arrow ) and double-click the "Caption" item. The description window of query is as follows: