4C-TV System
u Unlike Query by Example, which only supports a multiple-field And search, the Query Wizard also allows you to do a multiple-field Or search, as well as a multiple-field Except search. The Query Editor also allows you to search across tables.
u The Query Wizard is accessible from the Select->Search menu, or from the Special->Search popup in any QBE Screen.
u If any Saved Query is available under a User Menu, the filter selection dialog will be presented whenever the Advanced Query is selected. Here the user can select a previously saved query.
u The Query can be executed as saved (Query button), it can be modified before execution (Edit button), or an entirely new Advanced Query can be created (New button).
u After building a Query, hiting the Save button will bring the Filter Save dialog, where an identification and description can be entered. The query instructions will be save under the current User Menu, and will be available for any user with access to the same User Menu.