Sample Query Using a Question Mark

Suppose you want to create a saved filter, but you want to be able to specify a different value for one of the criteria each time you run the filter. You can use a question mark (?) as a keyword in the query.

This example creates a saved filter that queries for customer order lines where the item ordered is FA-10000, where the quantity ordered is more than 10, and where a certain customer number is specified.

1. Open the Customer Order Lines form.
2. Press Ctrl+Q.
3. In the Primary Criteria tab, specify:

   
   Item LIKE FA-10000

4. In the Additional Criteria tab, add these criteria:

   
   Qty Ordered > 10	

   
   Customer Number like ? 	

5. To save the filter, right-click and select Filter > Save.
6. When you run the saved filter, the system displays a prompt that asks for a value for the Customer Number.
7. Specify a customer number, for example 13, and click OK. The Customer Order Lines form displays, filtered on the item, quantity and customer number.