Command : Multi criteria search
Keyboard shortcut :
Icon :
The multi criteria search offers you access to:
| · | All the fields of the current table,
|
| · | All the fields of the tables in relation, whatever their relational levels are.
|
This command modifies the current selection.
Functioning
Certain characteristics of this dialogue are mentioned in the paragraph "Introduction of standard dialogues.
The principals of the search are dealt with in the paragraph "General points on the search"
Add a line
Use the button 'add' to add a line to your expression.
A new line is then placed at the end of the expression with the operator, by default, ET. You can modify the latter by clicking on the desired operator.
Insert a line
The principle is the same as for add. The new line is inserted before the selected line.
Modification of a line
Click on the line to be modified and proceed with all the modifications: object filed of the search, operator, comparison symbol, search value. The modifications made are taken into account gradually.
Saving/Opening a format
If your search format is liable to be used frequently you can memorise and store its structure with the help of the save… button.
If your document is placed in the 'Query' file it will be automatically integrated in the 'open…' list.
Note: Only the structure of your search format is saved and not its result.