3.3.5 Populate real column when writing to table

Specify whether the "real" column should be setup from the "virtual" column before writing to the table.

This option means that information entered in a virtual column will be written out to the table column(s) used to define the virtual columns. The virtual columns are the user input columns and will write information to a real column in the table. For example, the user enters a date in DD/MM/YY and it is then converted and stored in the table as YY/MM/DD.

Default=NO (unchecked).

Rules

• At least one of Populate real column when writing to table and Derive value when record is read must be selected. Both values may be selected.

Tips & Techniques

• This option is not supported for the 3.3.9 Mathematical Calculations virtual.

• You can add validation rules to virtual columns but be careful that the virtual column is included on the display so that it can be highlighted when an error occurs. In the case of a date virtual, you would only display the virtual column with the validation rule and not the real column on the screen.

• Virtual column derivation is also performed relative to predetermined joined columns. Refer to Access Route Definitions and 3.5.10 Derivation.

Also See

3.3.4 Derive value when record is read