I want to set a table value to be a CHAR (2) value representing the invoicing year (eg. "13"). Its not based strictly on calender year so I need to use a script.
Can I call this script from the Calculated Value dialog for Auto Enter of a table field value. If yes and if this is part of a 1 row table defining certain parameters for this application / database, will it execute each day the application is started up, thereby ensuring the correct value isstored for subsequent retrieval when generating invoice codes?
Or should I be defining a script to run at startup time for each session and loading this value into a global variable?