You can use text files, and tables retrieved via an ODBC connection, for field validation of invoices. You specify them in the . dialog
Each data item must consist of normal text, max. 127 characters.
There is one data item per line.
Each line is terminated by a line-feed character.
The data source can be anything that ODBC can connect to, for example an Access database, Microsoft SQL server, dBase, FoxPro, Paradox, SyBase, Oracle, and others.
The data source must be already set up when the system is ready to use it.
The table named must exist in the database.
The table must consist of one (1) column (with any name).
The maximum length of a data item in the column is 127 characters.
The user name and password used in the ODBC-connected data source are taken from Eilocal.ini.
When connecting to an Access database, the field data type must be set to text.