Is it possible to perform an AND/OR query? Example: Select all employees in Accounting AND/OR Finance. Thbeing able to and ANd or an Or query would also be nice. Rudy
Rudy, if you have two tables: Departments and Employees.
Set Edit as type as Lookup wizardon the Formatting tab in ASPRunner for Department field in Employees table.
Choose Departments table as Lookup table and Department as Display field, and set Select size more than 1. Now you can use Advanced searchpage to select all employees in Accounting OR Finance using Ctrl key.
