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.