3.3.4 Derive value when record is read
Specify whether the virtual column should be derived from the table after reading the real column.
This option means that the virtual column is created when you read the information from the table. The information will now be derived and available for display. For example, a date is stored as format YYYY/MM/DD so the table can be properly sorted by date, but the information is displayed to the user as DD/MM/YY.
Default=NO (unchecked).
Rules
-
At least one of Derive value when record is read and Populate real column when writing to table must be selected. Both values may be selected.
Tips & Techniques
-
Virtual column derivation is also performed relative to predetermined joined columns. Refer to Access Route Definitions and 3.5.10 Derivation.
Also See