Custom Fields
Custom Fields
In this panel you can name 10 alphanumeric and 10 numeric fields. These fields will appear in the Items register and the Item categories.
If you do not name fields, they will not appear in the Items register and the Item categories.
- Text Fields: select the name of the field and enter in the field on the right side the SQL statement for searching desired values in the SQL note.
| Field n |
Name of the individual custom text field.
This name will be used when searching an item with the Ctrl-F function in the Items register and Item categories register.
|
| Search |
You can enter data in custom fields manually. To simplify the procedure of entering, enter in the field for searching the SQL statement through which you can define data and tables that the program should offer for the entry. (For more information and use see Example on SQL statement for search in the Items register). |
2. Numerical Fields: Enter only the name of the field.
| Field n |
Name of the individual custom alphanumeric field.
This name will be used when searching an item with the Ctrl-F function in the Items register and Item categories register.
|
3. Attributes:
| Name |
Name of the individual custom text field.
This name will be used when searching an item with the Ctrl-F function in the Items register and Item categories register.
|
| Value |
You can enter data in custom fields manually. To simplify the procedure of entering, enter in the field for searching the SQL statement through which you can define data and tables that the program should offer for the entry. (For more information and use see Example on SQL statement for search in the Items register). |