|Enabled/Disable Database Lookup|
|Disable data lookup:||Select this option if you wish to disable data lookup completely. You will not see the Data tab in the Intell-tip window.|
|Enable for every column:||Select this option to enable data lookup for every column whose data type is
any one of the following types.
|Enable for columns that I choose:||If this option is selected, you must specifically assign a SQL query to every column for which you wish to enable data lookup. To assign a SQL query, double click that column in the catalog window. (See above)|
|Number of records to display:||Signifies the number of records to display in the Intell-Tip window. If the query returns more records, they will be ignored|
|Max length for character fields:||Lookup will be enabled for fields where the column length is less than this value. For example, if there is a remarks field in a table and its size is 255, data lookup won't be enabled for this field. This value only applies to character types.|
|Max record count for a table:||For large databases WinSQL may take a long time to fetch records from a table. Therefore, if you specify a value other than -1, WinSQL will only run data lookup queries for table having fewer number of rows than what you specify here.|