To connect multiple parameters to an object

The following steps can be used to connect two list boxes as parameters to an SQL statement in a grid object, and use a button to update the grid. Modify this procedure for other objects.

  1. Insert a grid as your target object, which uses a data source that requires two parameters. For example, show all orders for a specific customer and product.

  2. Insert a list box for the first set of parameters. For example, a list of customers.

  3. Insert another list box for the second set of parameters. For example, a list of products.

  4. Select Link Property To from the first list box, and select the Customer parameter.

  5. Select Link Property To from the second list box, and select the Product parameter.

  6. Insert a button named Update.

  7. Right-click the button and select Link Control To.

  8. On the Control Connections dialog box, select the mouseClicked control.

  9. Click the Add button and select the data source to connect to.

  10. Click OK on both dialog boxes.