Use these settings to:
Validate field values based on the value of another field. (See the overview, too.)
Translate field values to other values using a table. (See the overview, too.)
Connect the field with a specific database table in a database that contains a static list.
Field validation |
|
The type of table to use for field validation. |
|
The name of the table, or the file name. |
|
The data source, if you selected as the . |
|
Table name |
Dropdown lists containing the names of tables and associated columns available with the specified ODBC connection. |
See separate topic. |
|
| Connection table | |
Connect to |
The table to use for field validation when the value of one field depends on the value of another. This must be a table that you already created. |
Via field |
The field that controls the value of the current field. |
Connection 1 |
Uses the tables listed in the first column of the connection table to validate the field values. |
Connection 2 |
Uses the tables listed in the second column of the connection table to validate the field values. |
Translation table |
|
Table |
The table that shows how to translate the field values. |
Translate value when transferred |
Translates the value after validation and verification (that is, just before transfer). |
Note: All of these settings are also saved in the invoice definition.